>>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