>>Good point. The only place we need to use macro is fields and where clauses (and join if we build it as string). So, we can try to minimize its usage.
>>
>>Though I'm not sure what is quicker:
>>
>>lcSelect = whole select string
>>&lcSelect
>>
>>or
>>
>>select &lcFields from (lcTable) &lcJoin where &lcWhere into table (lcTable)
>
>Join and where unlikely needs macro. Latter would be faster.
>Cetin
Cetin,
Thank you for your answer, it's important to know.
I think, if you construct your joins and where condition as a string, you would have to macro expand it.
Thanks again.
If it's not broken, fix it until it is.
My Blog