Subject TIB_Script and Triggers on FB 1.5
Author Marco Lauria
Hello All,

I tried to run a script against FB 1.5 using TIB_Script.

The only particular thing that does this script is creating triggers for
multiple actions:

E.G.

CREATE TRIGGER TN021MAGMESE_AUAC2 FOR TN021 ACTIVE

AFTER INSERT OR UPDATE OR DELETE POSITION 0



If I run this script using IBManager the database is created correctly
(they use FIBPlus AFAIK).

If I run this script using normal TIB_Script I get the triggers created
as this:

CREATE TRIGGER TN021MAGMESE_AUAC2 FOR TN021 ACTIVE

POSITION 0



This causes not only that the triggers does not fire, but that the
database returns a stack overflow error to my client program.



Anyone here encountered something similar?



I use IBO 4.3.Aa



I tried also to generate the database using IB_SQL and the behaviour is
the same, so I suppose it is an IBO related problem.

If someone wants it, I can send also the database script.



Thanks in advance

Marco Lauria



[Non-text portions of this message have been removed]