Connection and transaction triggers

Started by James Mansionover 18 years ago1 messages
#1James Mansion
james@mansionfamily.plus.com

I've been looking at the new trigger features planned for Firebird 2.1
and I'm a bit jealous.

I'm interested in 'stateful' proc packages that can benefit from
accumulating data from updates
during a transaction and then performing an action at the end - perhaps
doing a bulk insert
in a pre-commit trigger, or communicating with an external system in a
post-commit trigger,
and using a begin tran or rollback trigger to tidy up the accumulator.

Would this be a difficult thing to add?

I quite like their temporary table treatment too.

James