Re: triggers

From: Ian Ledzion <ian.ledzion_at_lgxbow.com>
Date: Sat, 21 Jul 2001 21:29:48 GMT
Message-ID: <9i3q5t$111$1@rex.ip-plus.net>

There is no guarantee as to the order in which triggers get executed on the same event. If you need to have a set sequence, write one trigger and code the logic into it.

As we do a fair amount of stuff through triggers we have institued a system of 'omnibus' triggers, which fire for all events, and put all the logic into those.

"Orban Anita" <anita.orban_at_sysdata.siemens.hu> wrote in message news:3B448100.79D64414_at_sysdata.siemens.hu...
> Hello Everybody,
>
> Does anybody know how to reach: a trigger to be fired before an other
> one.
> They are declared on the same event, so they both should be fired
> "before delete" on the same table.
>
> Thanks for any idea you have...
> regards, Anita
>
Received on Sat Jul 21 2001 - 16:29:48 CDT