Subject | Re: [firebird-support] Re: Trigger Position |
---|---|
Author | Ann W. Harrison |
Post date | 2006-07-05T17:38:21Z |
Anderson Farias wrote:
on the version of Firebird, it might depend on the name of the
trigger, the order of declaration of triggers, or the phase of the
moon. Backing up and restoring the database may change the order
of execution of triggers if they have the same action time and
position.
Regards,
Ann
>The order of execution is arbitrary and unpredictable. Depending
> AND, what happens if u have more then 1 trigger of the same type
> (eg. 'before update') in the same position (eg. zero) ??
>
on the version of Firebird, it might depend on the name of the
trigger, the order of declaration of triggers, or the phase of the
moon. Backing up and restoring the database may change the order
of execution of triggers if they have the same action time and
position.
Regards,
Ann