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