triggers
Hi all,
I need some tips about triggers and inserting something in a table on
condition.
I created a trigger:
create trigger trig1
insert into table1 referencing new as new
for each row(
select from table2 where table2.id = new.id
if table2.xx = 1 then
insert into table3 values(xx)
end if
);
So I would like to test something in the trigger before I write something in a
table. Is that possible??
thanks for any tips!
Danny