Subject Re: [firebird-support] Re: update a field in after insert update
Author Ann W. Harrison
rogervellacott wrote:
> I suspect this would create an endless loop.
> <aharrison@...> wrote:
>> If the change must actually be done after the insert occurs,
>> you could try something like this:
>> update test_table s
>> set s.kyriga = 'test'
>> where s.<primary key> = new.<primary key>
>> replacing <primary key> with the name of the primary key field.

It would create an infinite loop if the trigger were an after
update - or some combination that includes update. But the
trigger we're talking about is after insert.

Good luck,