Subject | Re: Recursive triggers |
---|---|
Author | s.beames@mailbox.gu.edu.au |
Post date | 2001-06-26T17:56:08Z |
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