Subject | Re: [IBDI] Order of triggers with same position number? |
---|---|
Author | Ann Harrison |
Post date | 2000-06-15T14:48:06Z |
At 02:12 AM 6/15/00 -0400, Claudio Valderrama C. wrote:
three triggers defined as "before update position 8" they will
fire after all "before update" triggers with a position less
than 8, which includes those with no defined position, before all
those with a position higher than 8, and in an arbitrary order
among themselves.
Ann
>LangRef in page 81 says at the end:Whether or not you need a vacation, I believe that if you have
>«Triggers for a table need not be consecutive; triggers on the same action
>with the same position number will fire in random order.»
>
>Is this ok still? Why did I have the idea that there was some order among
>triggers that share the same POSITION... or do I need vacations?
three triggers defined as "before update position 8" they will
fire after all "before update" triggers with a position less
than 8, which includes those with no defined position, before all
those with a position higher than 8, and in an arbitrary order
among themselves.
Ann