Subject | Re: [ib-support] how can i a row to lock ? |
---|---|
Author | Helen Borrie |
Post date | 2003-04-18T10:02:51Z |
At 08:37 AM 18/04/2003 +0000, you wrote:
update mytable set anyfield=anyfield;
Just take care that you choose a field that is not affected by any Before
Update tiggers.
Until you commit your transaction, the row cannot be updated by any other
transactions. However, inside *your* transaction, you can now proceed to
edit the columns as required.
This technique is sometimes called "pessimistic locking". Firebird's
native locking scheme is optimistic.
heLen
>Other users dont modify this row.You can post a "dummy update", e.g.
>
>Sorry my poor english.
update mytable set anyfield=anyfield;
Just take care that you choose a field that is not affected by any Before
Update tiggers.
Until you commit your transaction, the row cannot be updated by any other
transactions. However, inside *your* transaction, you can now proceed to
edit the columns as required.
This technique is sometimes called "pessimistic locking". Firebird's
native locking scheme is optimistic.
heLen