>Thanks, Mark. This solution requires switching from the VFP SQLEXEC() function to the ODBC API function SQLEXECDIRECT() in order to get back the row count. Do I have to do this for SQL INSERT, UPDATE, and DELETE commands? Can I go ahead and switch over to the SQLEXECDIRECT() function altogether?
>
>Jim White
Switching over is the only way to get your rowcount consistently AFAIK. You can't use SQLEXEC for the Insert, Update, Delete then go to SQLROWCOUNT to get the count. In SQL Server, you can get the row count via SQLEXEC right after an update. The following thread discusses how to do that.
SQL Passthrough results Thread #
863999 Message #
863999
Mark McCasland
Midlothian, TX USA