Subject | Re: table lock |
---|---|
Author | Roman Rokytskyy <rrokytskyy@acm.org> |
Post date | 2003-02-06T13:05:21Z |
Nickolay,
either table locking or dummy update are the only solution to lock
group of records.
Best regards,
Roman Rokytskyy
> But you should be aware that this method of locking records (dummyThanks for pointing this out. However, before FB 1.5 is released,
> updates) is very likely to generate "Update conflict" exception
> during concurrent locking/updating.
>
> Explicit locks in FB1.5 never produce update conflicts
> in isc_tpb_read_committed+isc_tpb_wait modes.
>
> Implicit and explicit record locks are not equivalent in Firebird
either table locking or dummy update are the only solution to lock
group of records.
Best regards,
Roman Rokytskyy