>>>Hi All,
>>>
>>> I am trying to set up a select statement, I do not know the field name ahead of time. I do an AFIELDS() to get the field name, since there is only one field in the table. I need to change the field name to another name which I get before this select statement. I am thinks this way:
>>>

>>>SELECT EVALUATE(latmp[1]) as &lcnewfield. FROM &lcoldfile. ;
>>>   INTO TABLE lcnewfile DATABASE &lcTAbleDbc.
>>>

>>>
>>>Am I using the macro substitution too much? Can I do this easier? or nicer?
>>>
>>>TIA
>>>Beth
>>
>>I agree with the others, use the TEXTMERGE approuch. But not the macro substitution, use the ExecScript() function. It appears to be faster and clear code.
>
>ExecScript is faster??? Any demonstration code or resource? Even against textmerge...endtext approach I don't expect to be faster.
>Cetin


Perhaps not, or if so, only slightly. Macros have always slowed down the execution of code.