Posted by Kenneth Downs on 05/20/06 02:58

Chung Leong wrote:

> Jerry Stuckle wrote:
>> Keep the original values. Before updating, read the record in again and
>> compare
>> the values to the old ones. If they don't match, put the window back up
>> with the new values and tell the user.
>
> Or just add the original value to the where clause of the update
> statement. It's easier, probably fast, and avoids a race condition.

A nice touch.

I would add that you do need to then check for affected rows, so you can
notify the user if the update did not go through.

--
Kenneth Downs
Secure Data Software, Inc.
(Ken)nneth@(Sec)ure(Dat)a(.com)

[Back to original message]