Subject Re: [IBO] TIB_Script and Triggers on FB 1.5
Author jwharton@ibobjects.com
Show us the whole script please.
Are you using proper statement termination?

Jason

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
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