| Subject | Re: [ib-support] Does Firebird support column-based locking? |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2002-07-08T05:56:37Z |
On 5 Jul 2002 at 17:49, cbmrussn wrote:
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.
>For example, if I have ATable with FieldOne, FieldTwo and LockField,Yes. Write BEFORE UPDATE trigger for ATable and check if FieldTwo
>can I lock FieldTwo to read-only if LockField has a secific value,
>through the FireBird engine?
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.