469,603 Members | 2,154 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,603 developers. It's quick & easy.

Trigger question

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
1 1368
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.

Similar topics

1 post views Thread by Matik | last post: by
6 posts views Thread by Scott CM | last post: by
2 posts views Thread by robert | last post: by
5 posts views Thread by Bob Stearns | last post: by
3 posts views Thread by ChrisN | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.