At 05:27 PM 4/07/2006, you wrote:

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

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

./heLen