Subject Re: [firebird-support] update trigger do not fire
Author Helen Borrie
At 02:01 PM 25/02/2005 -0500, you wrote:

>We have tried a to update a table with a after update trigger an it does
>not seem to fire. We have Firebird/hpux800 (access method), version
>"HU-T6.2.697 Firebird Release Candidate 2". Is it a known problem?

It's a known problem for novices! <g>

You can't update the trigger's owner table in an After Update trigger. You
can update *other* tables in an After Update trigger.

Send the trigger's definition to the list and someone will help you with it.

./heLen