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
_______________________________________________________