---------- 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
http://www.firebirdsql.org/refdocs/langrefupd20-set-context.html 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?

-Philip