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)

• Next in forum: Re: How do I handle people going into the same record at the same in web app.
• Prev in forum: Re: Why some many PHP newsgroups?
• Thread view: Re: How do I handle people going into the same record at the same in web app.

[Reply to this message]