Subject Re: [firebird-support] Re: Maintain Summary Table with Database Trigger
Author unordained
---------- Original Message -----------
> If there was a longer term one, it might
> also eliminate the need for the field in the status table but I will
> definitely make use of it as it is.
------- End of Original Message -------

Besides USER_TRANSACTION, there's also USER_SESSION, which lasts past commit. See for details.
Instead of trying to replace the status field with a context variable, maybe a
table (not temporary) to store items that need refreshing would suit you better?