"Helen Borrie" helebor@... wrote:

> It's simpler than you think. "Before" triggers always execute before
> "After" triggers.

Thanks for the reply.

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.






___________________________________________________________
All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease of use." - PC Magazine
http://uk.docs.yahoo.com/nowyoucan.html