Обсуждение: 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