>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.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.