>I know but I'm glad someone at last pointed out to use the name expression instead of unnecessary text...endtext and the slower &.
>Cetin
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)
If it's not broken, fix it until it is.
My Blog