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

INteresting - what parameters did you play with in your testing and what was the speed difference ?

curious

thomas