Subject Re: [firebird-support] Avoiding pessimistic locking
Author Thomas Miller
This is the way most systems do it. You can also do it on a column by
column basis. This way
you are less likely to have any issues ever.

>1. When user A requests his changes to be posted, your application first
>does a select on that record and compares the returned data with those
>that A had before starting to edit the record. Requires that you save
>backups of A's pre-edit data of course. Also requires a primary key on
>the table in questions.
>
>
>Kjell
>
>

--
Thomas Miller
Wash DC Delphi SIG Chairperson
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://www.cpcug.org/user/delphi/index.html
https://sourceforge.net/projects/uopl/
http://sourceforge.net/projects/dbexpressplus