Is it safe to use triggers to update a summary table, everytime a
value in the detail table changes? E.g. when a user confirms an
order, the trigger will iterate through each line in the order and
update a couple of summary tables accordingly. The confirmation flag
is a field in the order header table, while the lines are in a
separate table.

I read a post previously that discouraged the use of triggers to do
this, but does this still apply to Firebird 1.5 (since there appears
to be some changes to how triggers work)?

Thanks in advance.

Regards
Ray