Subject Re: [firebird-support] Updating uncle and cousin tables in a trigger using UPDATE
Author Nando Dessena
Set et al,

S> in general I think updating of other tables ought to be done in AFTER
S> INSERT/UPDATE triggers, not BEFORE INSERT/UPDATE, but if you ask me why, I
S> have no idea.

One reason could be it's just a logical sequence: you update a total
when a quantity has changed, not just before you change it.
Another one: less things to undo in case the insert/update goes

Nando mailto:nandod@...