Re: Ensuring users don't overwrite each other (NOT a newbie question)

Yes thats an interesting idea, and this compare-and-modify-if-unchanged bit would be implemented via SQL IF statement(s) perhaps? Thanks Ollie "Hugh Bothwell" <hugh_bothwell@hotmail.com> wrote in message news:<20020201133107.1062.qmail@pb1.pair.com>... > > "Oliver Cronk" <ocronk@essex.ac.uk> wrote in message > news:NGENLNMKBJNBIAFJLPBHOEMPCBAA.ocronk@essex.ac.uk... > > Thanks for that answer, you filled in some of the blanks for the table / > > logging solution, but I am now looking at row locking instead of a > seperate > > table (and then doing things similar to what you outlined). > > Just a thought - if you have the user form echo a copy of the original data > back (ie in addition to the modified data), you can compare it to the > existing data and warn the user if the data has been changed in the interim. > You must make the [compare-and-modify-if-unchanged] atomic, but that's okay, > because it's all in the same script anyway - it becomes reasonable to do it > as a transaction. > >