Conflicting updates? Help!

[rirving]

Hello SeanR,


Thanks a lot!


Raymond

[Clunietp]

It sounds like you just need a pessimistic locking scheme, as Sean mentioned.

When User A edits the record, the record is then locked, so other users cannot even begin to edit the record without generating an error. The DBMS handles all of the locking, so you don't need to concern yourself with it.

If you need to restrict access to edits that are currently in progress, use pessimistic locking. This causes problems with a large number of users, however, due to the use of server side cursors and the DBMS having to manage the locks....