> but what i want is to recalculate the view/second table only when the last
> row of the block is inserted (or equivalent when the transaction where
> them are isnrted has been committed).

Then use an ON TRANSACTION COMMIT trigger, see http://www.firebirdsql.org/refdocs/langrefupd21-ddl-trigger.html You will probably need something to check if the recalculation should actually be done, as this trigger will be triggered for every commit.

Populate a real table with data and update it in the trigger. That will probably the closest you can get to materialized views in Firebird.

Mark
--
Preisknaller: GMX DSL Flatrate für nur 16,99 Euro/mtl.!
http://portal.gmx.net/de/go/dsl02