hi,
try use this way :
for i = first_sequence_cone_field to last_sequence_cone_field
text1.text = rs.Fields(i).Value
next
hope this can solve.
Thanks.
tavvasateeshkumar wrote:
>
> hai
>
> i am in trouble in solving one problem in vb , could you please help
> me . i will explain in detail what the problem is.
>
> cone1,cone2. ... cone150 has the values in database.
>
> i want to handle these values with for loop.
>
> for i = 1 to 150
> dim l as string
> l="rs!cone"& trim(str( l))
>
> text1.text=l
>
> end for
>
> here i want the value of cone1 to cone150 by calling "l".
>
> mostly we use foxpro , in that we can call the value of one variable
> with &l , then we will get the value of cone1 .
>
> could you pls help me.
>
>
