Subject | Re: Trigger Position |
---|---|
Author | Oluwatope Akinniyi |
Post date | 2006-07-04T18:26:51Z |
"Helen Borrie" helebor@... wrote:
Having these
----
CREATE TRIGGER BEDS1 ACTIVE
BEFORE INSERT POSITION 0
CREATE TRIGGER BEDS2 ACTIVE
BEFORE INSERT POSITION 1
CREATE TRIGGER BEDS3 ACTIVE
BEFORE INSERT POSITION 2
Are these right
CREATE TRIGGER BEDS4 ACTIVE
AFTER INSERT POSITION 0
CREATE TRIGGER BEDS5 ACTIVE
AFTER INSERT POSITION 1
CREATE TRIGGER BEDS6 ACTIVE
AFTER INSERT POSITION 2
or these
CREATE TRIGGER BEDS4 ACTIVE
AFTER INSERT POSITION 3
CREATE TRIGGER BEDS5 ACTIVE
AFTER INSERT POSITION 4
CREATE TRIGGER BEDS6 ACTIVE
AFTER INSERT POSITION 5
-----
Thanks for your help.
Chris.
___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" The Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html
> It's simpler than you think. "Before" triggers always execute beforeThanks for the reply.
> "After" triggers.
Having these
----
CREATE TRIGGER BEDS1 ACTIVE
BEFORE INSERT POSITION 0
CREATE TRIGGER BEDS2 ACTIVE
BEFORE INSERT POSITION 1
CREATE TRIGGER BEDS3 ACTIVE
BEFORE INSERT POSITION 2
Are these right
CREATE TRIGGER BEDS4 ACTIVE
AFTER INSERT POSITION 0
CREATE TRIGGER BEDS5 ACTIVE
AFTER INSERT POSITION 1
CREATE TRIGGER BEDS6 ACTIVE
AFTER INSERT POSITION 2
or these
CREATE TRIGGER BEDS4 ACTIVE
AFTER INSERT POSITION 3
CREATE TRIGGER BEDS5 ACTIVE
AFTER INSERT POSITION 4
CREATE TRIGGER BEDS6 ACTIVE
AFTER INSERT POSITION 5
-----
Thanks for your help.
Chris.
___________________________________________________________
Try the all-new Yahoo! Mail. "The New Version is radically easier to use" The Wall Street Journal
http://uk.docs.yahoo.com/nowyoucan.html