Subject Re: [Firebird-Architect] transient data sets and procedures
Author Jacqui Caren
Dmitry Yemanov wrote:

> Ann et al,
> Regarding temporary datasets vs PSQL.

One trick I have used with Oracle that is difficult to
do otherwise is to

apply before update triggers (per row) to populate
a package array and update package counters.

apply a after update trigger to consume the
values and update stats tables, clearing counters
and arrays when done.

As the package scoped vars are per transaction
but are visible to all triggers/SP's we have a
clean and simple way of passing data between
triggers during the execution of one or more
queries within a transaction.

It would be neat if FB had similar features
and I hope that temp tables (per transcation?)
go some way towards this.