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 ...".
>
>
>Adriano
>
>
>

Adriano,

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

see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br



--
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