>Sorry to be so dull Larry but what does this bit actually do?
>
>lcsql = tcSQL + [ into cursor ] + tcAlias
> &lcsql
Chris,
If you passed in the following SQL statement and alias:
tcSQL = "select * from MyTable where MyField > 50000"
tcAlias = "v_Myview"
The concatenation above gives you the following:
select * from MyTable where MyField > 50000 into cursor v_MyView
The macro substitution line executes the command as if you typed it in and hit Enter. The SQL select is executed and builds a cursor in the current datasession.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao