trigger

xiaoer20

我想在insert触发操作后,该触发操作对触发语句作用的每一行执行一次,请问怎么写.
例如:
CREATE TRIGGER command_tri
INSERT ON command1
REFERENCING NEW AS post
FOR EACH ROW(EXECUTE PROCEDURE command_spl()
这样写好象只要insert 操作开始就触发该trigger,我想在insert成功以后再触发这个trigger,请各位帮帮忙,我比较急

xiaoer20

请各位关注~~~~~

satoni

既然是每行触发就不能在整个insert完成之后才能触发，你each row的值可要带进去存储过程的啊

xiaoer20

CREATE TRIGGER command_tri
INSERT ON command1
REFERENCING NEW AS post
FOR EACH ROW(EXECUTE PROCEDURE command_spl(post.drum_id,post.m_flag) )我需要用到insert成功后的值,我一次只insert一笔资料,我目前遇到的问题是insert不成功也会触发trigger,请各位帮帮忙.

satoni

Online databases with logging will automatically roll back both the
trigger event and the trigger action if either fail. Any other SQL
statements within the transaction will not roll back unless the
ROLLBACK WORK is executed or the program stops without completing
the transaction.
日志方式下是会rollback的。起码我的环境可以；

xiaoer20

thmis                 thmis       rootdbs              06/15/2001     U这样是不是不可以rollback了