|Subject||Re: [firebird-support] Re: it's possible to have a view cache?|
> but what i want is to recalculate the view/second table only when the lastThen 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.
> row of the block is inserted (or equivalent when the transaction where
> them are isnrted has been committed).
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.
Preisknaller: GMX DSL Flatrate für nur 16,99 Euro/mtl.!