Dynamic Variable Name 1

[jvande]

I have a function to read in several values from a record
F1,F2,F3

Record_set = ORS
Count =3
Function Read_Database(ByVal Record_Set, ByVal Count)
I=1
do until I>Count
F&I=Record_Set("F"&I&"&quot
I=I+1
loop
End Function

I would like my resulte to be F1= F1 value from database, F2 = F2 value from database and so on. I can't seem to get the variable F&I to work. How do I get that syntex correct?

Thanks,
Josh

 

[Tarwn]

Um, you don't. You can't name variables dynamically like that, sorry.
Another option would be to use an array or delimited string variable.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---

http://www.tuxedo.org/~esr/faqs/smart-questions.html

 

[Jonax]

Check these:
[thread333-259851], [Thread333-176827]... This is not a bug - it's an undocumented feature...
;-)

 

[Tarwn]

Nice, I wasn't aware of the execute command, star for bringing up something completely new to me
Whats funny is how many sites I remember tellling me that this wasn't possible a year or two again when I searched, must have been because I was basing the search on eval and evaluate.

-Tarwn --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
FAQ FAQ20-2863
= new Forums.Posting.General.GettingAnswers()

 

[Jonax]

Thx m8 This is not a bug - it's an undocumented feature...
;-)