Subject Re: [ib-support] how can i a row to lock ?
Author Helen Borrie
At 08:37 AM 18/04/2003 +0000, you wrote:
>Other users dont modify this row.
>
>Sorry my poor english.

You can post a "dummy update", e.g.

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