>>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.
Thank you. Yes, after I read Naomi's message, I remembered that I used OUTPUT clause before. And it works.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham