Subject | TIB_Script and Triggers on FB 1.5 |
---|---|
Author | Marco Lauria |
Post date | 2004-04-14T09:35:26Z |
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]
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]