column name as variable?

[MichaelTJ]

is this possible in some way...

dim locdata as string
dim val as string
val = "col1"
.......
locdata = Cursor1.GetString(val)
...

locdata returns the value in col1.... is there someway to do this?

 

[Erel]

Yes. It doesn't matter whether the string is written directly of passed as a variable.

 

[MichaelTJ]

syntax?

could you give me a code example... syntax.... it does not like what i gave as an example and returns the result that there is no such column as val.... i've thought that i had tried every soncievable combination of single and double quotes with no luck..... the value of val is definitely the column name when the attempt to retrieve the data is made but as i say it gives and error message

 

[MichaelTJ]

well shoot!!!

went back and ran the code as is and i worked just fine..... strangeness