Subject | Re: [firebird-support] Duplicate Trigger Positions |
---|---|
Author | Thomas Steinmaurer |
Post date | 2005-07-12T20:48:11Z |
> Awesome - Thank you. This did highlight a few more but it brought upHmm, the result tells you that there are three AFTER UPDATE
> another question:
>
> This query reported for instance my "vessel" table - I have a before insert
> and after update trigger (using FB 1.03) both at position 0.
>
>
>
> I would imagine this is ok as one trigger or the other/not both will be
> invoked.
>
> This query is reporting the following:
>
> VESSEL 4 1 3
>
> VESSEL 6 1 3
(RDB$TRIGGER_TYPE = 4) triggers at position 1 and three AFTER DELETE
(RDB$TRIGGER_TYPE = 6) triggers at position 1 on VESSEL, if I recall the
trigger type constants correctly.
Regards,
Thomas