Subject Re: [firebird-support] Locking a field (column) from further update
Author Nick Upson
In article <d1fenn+gi8u@...>, Salisburyproject wrote:
> Can I somehow lock a column, so a value cannot be further modified by
> any mean (API, ODBC, etc.). E.g. - add the value at row insertion and
> never allow further update.

Define an before update trigger that does

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