Subject | Re: [firebird-support] Locking a field (column) from further update |
---|---|
Author | Nick Upson |
Post date | 2005-03-18T20:54:09Z |
In article <d1fenn+gi8u@...>, Salisburyproject wrote:
new.field = old.field
or
if new.field <> old.field then
raise exception
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly
> Can I somehow lock a column, so a value cannot be further modified byDefine an before update trigger that does
> any mean (API, ODBC, etc.). E.g. - add the value at row insertion and
> never allow further update.
new.field = old.field
or
if new.field <> old.field then
raise exception
--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly