SEO

#1 (**permalink**) 04-09-2008, 06:13 PM

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

#2 (**permalink**) 04-09-2008, 06:13 PM

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#3 (**permalink**) 04-09-2008, 06:13 PM

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Trigger Priority