>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
Check nResult which gives the number of records that are updated.