Hi Hackers, Alphabetical order of triggers sometimes makes me write a_Recalc or z_Calc to be sure it´ll be the first or the last trigger with same event of that table
Oracle and SQL Server have FOLLOWS and PRECEDES when defining trigger execution order. Firebird has POSITION, which I like it more. What do you think about it, do you know an old/abandoned patch that was not committed ? CREATE TRIGGER RECALC_THAT BEFORE UPDATE POSITION 1 ON ORDERS... CREATE TRIGGER DO_OTHER_CALC BEFORE UPDATE POSITION 2 ON ORDERS... Regards, Marcos