variables & loops

[vlitim]

I am trying to create a variable in a loop eg

While done = "FALSE"
count = count + 1
dim levelcount
levelcount = info from dbase

Wend

if this loops through 3 times, I want to be able to have 3 variables at the end: level1, level2, level3.

 

[link9]

Well, if the above loop executes more than once, you will get a runtime error for trying to dim the same variable name twice. My suggestion would be to create an array and fill an element on each iteration of the loop:

dim levelCounter(numOfElements)
dim count
count = 1

While not done
    levelcount(count) = info from dbase 
    count = count + 1
Wend

Performance will always improve if you use boolean evaluation of a boolean variable (not). I also have a question of how

 done

is going to change... but I'll leave that up to you.

hope it helps!
Paul Prewett

 

[vlitim]

Thanks just what I wanted

cheers for the help