I have a requirement to insert a record into a table from that
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?

regards, Colin

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
AS
begin
/* 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.code,
new.val1,
0);
new.val1 = 0;
end;
end