Arden,

For readability, and to reuse or make generic SQLexec calls, I use to build the SQL command into a character string and then call the SQLexec function. This way I create very very long strings and have no problems:

 gObjtSQLcommand = "Select Count(*) as Records From " + IIf (Empty (cTableOwner), "", cTableOwner + ".") + cTableName

 If SqlExec (gSQLHandle, gObjtSQLcommand, "SQLcurSelect") <> 1
    . . .

Hope this helps,

Fernando