Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
Thread How does TRIGGER AT work ?
Thu, Oct 10 2019 3:59 AMPermanent Link

Robert Perelegre

Hi

I have a table with two triggers, one BEFORE ALL and other BEFORE DELETE.
I need to first run the BEFORE ALL Trigger and after the BEFORE DELETE Trigger.

I create the triggers like this :
CREATE TRIGGER "TBA_Pack_Cap" BEFORE ALL ON "Pack_Cap"
AT 1
BEGIN

CREATE TRIGGER "TBD_Pack_Cap" BEFORE DELETE ON "Pack_Cap"
AT 2
BEGIN

If I see the SQL of the trigger in the ElevateDB Manager and I don't see the AT clause.

The same happens if I use the Execution Order if I create or alter the trigger using the ElevateDB Manager

What I do wrong ?

Regards
Robert
Image