insert to table with triggers
Posted in 2000
Carl Y. Wu — — source: Informix-list mailing list archive (1991-1998)
Question: Are the triggerred actions garanteed to be done before control
returns to the application from the triggering SQL statement?
Any help greatly appreciated!
Carl Wu
Example:
insert into table t1 values (t1_rec.*) ;Then Call a function which use t1.c2 in "where" clause ----- Any garantee?
The table has a trigger like this:
create trigger trig1insert on t1
referencing new as new_rec
for each row
(update t1 set t1.c2 = some_value where (t1.c1 = new_rec.c1) );
C1 is the primary key of table t1.
IDS 7.30.UC8