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