Hi,

Does trigger position counts for the whole table or for each trigger type?

I mean which is right among these two:

----
CREATE TRIGGER BEDS1 ACTIVE
BEFORE INSERT POSITION 0

CREATE TRIGGER BEDS2 ACTIVE
AFTER INSERT POSITION 0

CREATE TRIGGER BEDS3 ACTIVE
AFTER DELETE POSITION 0
----

or
----
CREATE TRIGGER BEDS1 ACTIVE
BEFORE INSERT POSITION 0

CREATE TRIGGER BEDS2 ACTIVE
AFTER INSERT POSITION 1

CREATE TRIGGER BEDS3 ACTIVE
AFTER DELETE POSITION 2
-----


Thanks.

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