>Hi,
>
>Say I am executing the SQL Update from a VFP PRG file, against a SQL Server. This is the syntax:
>

>cSqlUpdate = "update MyTable set Field1 = '12345' where Field2 = 'XYZ'"
>nResult = SQLEXEC(hCon, cSqlUpdate)	
>

>
>How do I determine, in my PRG code, that a record has been updated? That is, without searching for the Field2 = 'XYZ'.
>
>TIA

In one replication service I found that the only way to 100% ensure the proper update has been done, I had to requery from the database and compare the results. Turned out we found truncated values (that was in MySQL and numeric values out of range silently got truncated - I think later versions of MySQL added more strict options to prevent that from happening), also divide by zero errors that never raised an error and were undetected before. So that solution was not depending on the SQL syntax of the database server, but it added some additional overhead. For SQL Server the solution of Naomi is probably more efficient.