Is this true even if the update is done by an "UPDATE <tablename> SET
<blah>=<blech> WHERE...." type of statement in the trigger???

--- In ib-support@y..., Helen Borrie <helebor@d...> wrote:
> At 10:45 AM 26-06-01 +0000, you wrote:
> >G'day all,
> > if an after update trigger happens to update the same table,
the
> >trigger will be fired again, but does this happen immediately
after
> >the update statement is executed, or after the initial trigger
code
> >completes?
>
> It's not an issue.
> The After Update trigger fires after the **update** (no kidding?) -
updating is finished by then. You can only affect the update values
in a Before Update trigger. AI triggers are for doing external
stuff - writing to other tables, firing events, etc.
>
> -- HB
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________