Create view, and hang your triggers on this view
instead of on the table. Such triggers will fire
only when updating the view, not when updating
the table itself.
(just be prepared for unpleasant incompatibility
with triggers on views that will come in FB2)

Ivan

----- Original Message -----
From: "sdbeames" <s.beames@...>
To: <firebird-support@yahoogroups.com>
Sent: Friday, March 18, 2005 1:20 AM
Subject: [firebird-support] Recursive Triggers
>
> Is it possible to temporarily disable an after update trigger
> from within itself to prevent recursion where the trigger
> causes further edits to the same table?
>
> In my particular case it seems difficult to solve this by
> just looking at the incoming field values and bypassing the
> offending code.
>
> Thanks,
> Steve