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