"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.




___________________________________________________________
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