Hi,

Is it possible to pass a var by reference in an sqlcommand to get the results of a sqlcommand?

That is, I know its possible to do the following from fox:

SQLEXEC( lnHandle, "SELECT * FROM Customer WHERE Id = ?lnId", "Results") where lnId is a fox var, but is it also possible to do something like the following...

SQLEXEC( lnHandle, "SELECT ?lnCount = COUNT(1) FROM Customer")
where UDFPARMS are set to reference

Can anyone let me know the correct syntax?

Thanks

Mace