Subject Re: Recursive triggers
Author s.beames@mailbox.gu.edu.au
Aha! Thanks Sean!

--- In ib-support@y..., "Leyne, Sean" <InterbaseSupport@a...> wrote:
> Steve, the trick is to create a new column TRIGGER_INACTIVE and
only set
> a value when you are updating the data from the trigger, as in:
>
> UPDATE <tablename>
> SET <blah>=<blech>
> SET TRIGGER_INACTIVE = 1
> WHERE....
>
> Then modify your trigger(s) as required to check for the value of
the
> TRIGGER_INACTIVE column.
>
>
> Sean