>Dear Vlad Grynchyshyn,
>
>Thank you for your help and I tested. It returned no. of records processed using VFP Native SQL Command. When I use SQLExec to issue the SQL command via ODBC, it can't. Do you know have any way to return no. of records processed? Thanks a lot....
>
>Best Regards,
>
>Justy Chow


You can use the @@ROWCOUNT system variable to get this provided you execute it immediately after the update. So, you'd do something like this in VFP:

=sqlexec(liConnection,"update table set x = y where {condition};" + ;
   "select @@rowcount as rowcount",curResults)
?curResults.rowcount

The trick is "chaining" the commands together. The semicolon in the middle of the command string does that.