forum.vdsworld.com

CodeScript · Posted: Sun Oct 19, 2003 6:12 am Post subject: SELECT Statement in VDS

SELECT Statement in VDS

Serge · Posted: Sun Oct 19, 2003 9:50 am Post subject:

i agree with you here codescript...it would be very handy

serge

Skit3000 · Posted: Sun Oct 19, 2003 9:54 am Post subject:

Here is some code which can do such a thing: Smile

http://forum.vdsworld.com/viewtopic.php?p=15320#15320

CodeScript · Posted: Sun Oct 19, 2003 6:16 pm Post subject:

I know one can do a custom function like that, but each branching to a custom function takes time which is only a lttle less than time taken after a INFO box display.
Some may still disagree about this sluggishness but I have tested it,

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

I know this is a dumb question, but what does a SELECT statement
do? Embarassed

Protected · Posted: Sun Oct 19, 2003 8:53 pm Post subject:

SELECT %%AA
CASE 1
rem Do this
CASE 2
rem Do that
CASE Popcorn
rem Do something
ELSE
rem Whatever
END

would equal :

IF @EQUAL(%%AA,1)
rem Do this
ELSE
IF @EQUAL(%%AA,2)
rem DO that
ELSE
IF @EQUAL(%%AA,Popcorn)
rem Do something
ELSE
rem Whatever
END
END
END

If a select statement is too hard to implement in vds a similar (or even better) result could be achieved with ELSEIF since it would allow usage of functions other than equal...

IF @EQUAL(%%AA,1)
rem Do this
ELSEIF @equal(%%AA,2)
rem Do that
ELSEIF @equal(%%AA,popcorn)
....
ELSE
....
END

Protected · Posted: Sun Oct 19, 2003 8:57 pm Post subject:

Perhaps the most effective of all would be SELECT with a function that would be replaced by the CASE parameter, for increased flexibility, so the previous example would be:

SELECT @equal(%%AA,@selcase())
CASE 1
rem Do this
CASE 2
...etc...
END

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

Thanks for explaining to Protected. Smile

vdsalchemist · Posted: Mon Oct 20, 2003 2:08 pm Post subject:

Hi All,
Well I guess no one remembers my mpSelect.dll that is free. It was my first VDS DLL and it has this already Laughing

I think I need to update it not sure.

Tommy · Posted: Mon Oct 20, 2003 6:20 pm Post subject:

CodeScript · Posted: Tue Oct 21, 2003 3:16 am Post subject:

I think I should *really really* stop this wish thingy especially those wishes which are more of convenience kinda rather than a *absolute* need. This may drive away newbies/guest users thinking that VDS is not self sufficient/incomplete and even doesn't support this?? etc.

While fact is that VDS has grown into a language which can accomplish majic or miracle things even for a person who absolutely does not know even a single word about programming.

Also I think such silly wishes might have even cast doubts about my sincierety/respect to VDS which isn't true.

Anyway enough of wishing here Embarassed

Dr. Dread · Posted: Tue Oct 21, 2003 5:27 am Post subject:

Serge · Posted: Tue Oct 21, 2003 8:12 am Post subject:

i agree dr dread...it is a wish list Smile

in defence of codescript, i would prefer the syntax of SELECT and CASE rather than IF and ELSIF even though the latter can do the former...i think that having it built in would be a nice addition...me thinks...

serge

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

CodeScript, your wishes are very good ones. Don't stop them. Very Happy

jules · Posted: Tue Oct 21, 2003 10:50 am Post subject:

I think if this were to be implemented in VDS it would be something like:

GOTO <label1>, <label2>

where <label1> could be a variable, and <label2> is where it would go if the label didn't exist. The interpreter has to have a label to go to.

But you can achieve the same thing using the existing GOTO, setting OPTION ERRORTRAP to cater for the ELSE case. I don't know if it would be possible to make a user-defined command to do this, in a way that looked more like a SELECT statement...