Thread: Trigger Priority
Is there a way to determine the order that triggers are executed? We are converting from SQL Anywhere 9 and one of the features that they have is the ability to add a order statement to triggers. This allows from a programmatic way to control how triggers are fired if there is more than one trigger for a particular type (before, after) the insert, update, delete commands.
Best Regards,
Michael Gould
All Coast Intermodal Services, Inc.
904-376-7030
Best Regards,
Michael Gould
All Coast Intermodal Services, Inc.
904-376-7030
--- Mike Gould <mgould@allcoast.net> wrote: > Is there a way to determine the order that triggers are executed? We are converting from SQL > Anywhere 9 and one of the features that they have is the ability to add a order statement to > triggers. This allows from a programmatic way to control how triggers are fired if there > is more than one trigger for a particular type (before, after) the insert, update, delete > commands. The triggers fire in alphbetical order. Regards, Richard Broersma Jr.
am Tue, dem 03.07.2007, um 12:11:01 -0400 mailte Mike Gould folgendes: > Is there a way to determine the order that triggers are executed? We are alphabetically Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net