Subject Re: [firebird-support] How to avoid Triggers' infinite loop?
Author Ann W. Harrison
Anderson Miranda wrote:
>>My solution is by creating a table which holds record flag for the
>>running trigger. The table should have a field TRANSACTION_ID for
>>storing the CURRENT_TRANSACTION variable.
> Anyways, thanks for the suggestion... I'm prolly going to do this way.

Don't. In the long run, it doesn't work. Or, if you must, combine it
with the date or some other value that won't repeat. I'd get a number
from a generator and use that, storing it in a special table so it's
accessible within triggers and procedures.