Subject Re: table lock
Author Roman Rokytskyy <>

> But you should be aware that this method of locking records (dummy
> 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

Thanks for pointing this out. However, before FB 1.5 is released,
either table locking or dummy update are the only solution to lock
group of records.

Best regards,
Roman Rokytskyy