|Subject||RE: [firebird-support] Recursive trigger|
>I have a requirement to insert a record into a table from thatCould you give us more details on "behaving very strangely"
>table's "before insert" trigger.
>The mechanism works, but thereafter my database starts behaving very
>strangely. (tried with FB 1.5 RC7 and RC8)
>I have read somewhere that it is not recommended to perform any
>action in a trigger that may cause the trigger to be re-invoked.
>Does anybody have any ideas?
>a simplified example follows:
>(and I really do have a strong argument to want to do this!)
>CREATE TABLE TABLE1 (
> ID INTEGER,
> PRODUCTCODE INTEGER,
> VAL1 INTEGER,
> VAL2 INTEGER
>CREATE TRIGGER TABLE1_BI0 FOR TABLE1
>ACTIVE BEFORE INSERT POSITION 0
> /* when val1 and val2 both non-zero, rather write 2 records:
> one with only val1, one with only val2
> if ((new.val1 <> 0) and (new.val2 <>0)) then begin
> insert into table1(id, productcode, val1, val2)
> values (gen_id(table1_gen, 0),
> new.val1 = 0;