Subject | How to detect a record changed between read and update? |
---|---|
Author | Constantijn Wolfs cw.s |
Post date | 2004-06-17T13:46:26Z |
Hello,
I want to raise an exception when a record changed between the original
read and the update with a sp.
I could do a select on the old values and proceed with the update when
the record was found. But is there a better way to do this, making the
change of overwriting other updates as small as possible, without locking?
Constantijn
I want to raise an exception when a record changed between the original
read and the update with a sp.
I could do a select on the old values and proceed with the update when
the record was found. But is there a better way to do this, making the
change of overwriting other updates as small as possible, without locking?
Constantijn