Subject | Re: [firebird-support] Trigger position question |
---|---|
Author | Martijn Tonies |
Post date | 2004-12-07T10:31:18Z |
Hello Daniel,
If there are multiple triggers with the same position, they will
fire in "no particular order". That is: implementation defined.
This, currently, means the will fire alphabetically, but don't
count on it.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
> When I define a trigger, if I omit the position statement and othertriggers
> for the same table exist, will the trigger with no position statement bethe
> last or the first. Do the positions start at zero or one?-Max(SmallInt).
If there are multiple triggers with the same position, they will
fire in "no particular order". That is: implementation defined.
This, currently, means the will fire alphabetically, but don't
count on it.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com