By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,870 Members | 1,236 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,870 IT Pros & Developers. It's quick & easy.

Trigger question

P: n/a
Hi list,

i'm a bit confused. I have a table with a trigger after insert. It is
possible that this trigger will do inserts in the same table, but is the
after insert trigger fired again in this case? (I would need this)

e.g.

USER INSERT

BEFORE TRIGGER
AFTER TRIGGER

->DECIDES TO INSERT X ROWS IN THE SAME TABLE

->BEFORE TRIGGER (this one is fired for each row the after trigger inserts)

->AFTER TRIGGER AGAIN???? FOR EACH ROW THE AFTER TRIGGER INSERTED

thnx a lot.
Daniel
Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ok, it is working fine.
Hi list,

i'm a bit confused. I have a table with a trigger after insert. It is
possible that this trigger will do inserts in the same table, but is the
after insert trigger fired again in this case? (I would need this)

e.g.

USER INSERT

BEFORE TRIGGER
AFTER TRIGGER

->DECIDES TO INSERT X ROWS IN THE SAME TABLE

->BEFORE TRIGGER (this one is fired for each row the after trigger inserts)

->AFTER TRIGGER AGAIN???? FOR EACH ROW THE AFTER TRIGGER INSERTED

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.