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.

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