Subject | get new values in trigger |
---|---|
Author | orhanturhan |
Post date | 2009-08-24T09:58:15Z |
for example
CREATE OR ALTER TRIGGER CUSTOMER_BI FOR CUSTOMER
ACTIVE BEFORE INSERT POSITION 0
as
begin
........
for
select rdb$field_name from rdb$relation_fields
where rdb$relation_name='CUSTOMER'
into field_name
new.field_name=upper(new.field_name)
.........
end;
i want to "new.field_name=upper(new.field_name)" row.
i want write only one sql for all tables in trigger and all field values upper case.
CREATE OR ALTER TRIGGER CUSTOMER_BI FOR CUSTOMER
ACTIVE BEFORE INSERT POSITION 0
as
begin
........
for
select rdb$field_name from rdb$relation_fields
where rdb$relation_name='CUSTOMER'
into field_name
new.field_name=upper(new.field_name)
.........
end;
i want to "new.field_name=upper(new.field_name)" row.
i want write only one sql for all tables in trigger and all field values upper case.