>>>How do I determine, in my PRG code, that a record has been updated? That is, without searching for the Field2 = 'XYZ'.
>>>
>>
>> Are you looking for absolute verification that indeed, the row was changed, and specifically, that the column was changed from 'ABC' to 'XYZ'?
>
>Yes.
In this case use OUTPUT clause of the update command (e.g. OUTPUT Deleted.Field, Inserted.Field and then examine the cursor.
If it's not broken, fix it until it is.
My Blog