Subject Re: [Firebird-Architect] NOT UPDATABLE fields
Author Alexandre Benson Smith
Adriano dos Santos Fernandes wrote:

>Many of my tables have fields with the values should not be changed.
>These tables has on update triggers that update others tables.
>For integrity of the data (in case of the value is changed), I have to
>check if old.field <> new.field and raise exception or maintain
>complicated triggers with update the others tables depending on the old
>value too.
>This syntax will be very helpful:
>create table t
> f integer not updatable
>I think the flag can be stored in rdb$relation_fields.rdb$update_flag.
>Check should be done at execution time because flag can be changed with
>"alter table ... type ...".

Do you meant that the value should be only provided on insert, and no
update be allowed ?

see you !


Alexandre Benson Smith
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 266.4.0 - Release Date: 22/02/2005