Subject Re: [ib-support] Does Firebird support column-based locking?
Author Dimitry Sibiryakov
On 5 Jul 2002 at 17:49, cbmrussn wrote:

>For example, if I have ATable with FieldOne, FieldTwo and LockField,
>can I lock FieldTwo to read-only if LockField has a secific value,
>through the FireBird engine?

Yes. Write BEFORE UPDATE trigger for ATable and check if FieldTwo
is going to be changed and LockField has a specific value. Raise an
EXCEPTION and update won't be performed with an error message.
Replace NEW value of FieldTwo by OLD one and FieldTwo will keep it's
value silently.

SY, Dimitry Sibiryakov.