>>I have a table with 6 fields. ( MyTable.Name1,Name2,Name3,Name4,Name5,Name6) all numeric content
>>I want to store value of these fields into memory variables in a for statment.
>>
>>FOR nCounter = 1 TO 6
>> m.Name????nCounter???? = MyTable.Name????nCounter????
>>ENDFOR
>>
>>How can i do this?
>>Thanks for your help.
>
>
>FOR nCounter = 1 TO 6
> lnVarName = [VarName]+TRANSFORM(nCounter)
> &lnVarName = EVALUATE([MyTable.Name]+TRANSFORM(nCounter))
>ENDFOR
>
>
>or better:
>
>SCATTER NAME oVar FIELDS LIKE Name*
>? oVar.name1
>? oVar.name2
>? oVar.name3
>? oVar.name4
>? oVar.name5
>? oVar.name6
>
Thank you very much