>>Yes. I'd prefer to call stored procedure, i.e. SQLExec(c,"execute ...") which will do the abovementioned operations.
>
>Neat thing about the MS SQL Server ODBC driver is that if the command contains anything that the driver cannot translate, it passes it to SQL Server as is. This provides a way to submit non-ODBC SQL commands within using the ODBC escape clause.
>
>-Mike
Agree. One more nice thing is that any SELECT command from stored procedure will generate cursor on VFP side if you call the procedure using pass-through SQL.
Edward Pikman
Independent Consultant