Hello All,

I found this problem with CREATE TRIGGER under FB 1.5 (tried with RC6
and the official release).

If I issue this statement:

CREATE TRIGGER TN021magmese_AUDA FOR TN021 ACTIVE

AFTER UPDATE OR INSERT OR DELETE POSITION 0

AS

DECLARE VARIABLE numrec INTEGER;

BEGIN

// BLAH BLAH BLAH

END^



The trigger is compiled as

CREATE TRIGGER TN021magmese_AUDA FOR TN021 ACTIVE

POSITION 0

AS

DECLARE VARIABLE numrec INTEGER;

BEGIN

// BLAH BLAH BLAH

END^



And nothing works well instead after a post on the table TN021 I receive
on the client a strange "stack overflow error for excessive recursions"
from the server.

If I issue the statemen as:

CREATE TRIGGER TN021magmese_AUDA FOR TN021 ACTIVE

AFTER INSERT OR UPDATE OR DELETE POSITION 0

AS

DECLARE VARIABLE numrec INTEGER;

BEGIN

// BLAH BLAH BLAH

END^



The statement is compiled correctly and everything works fine.



Is this a "designed" behaviour?



Regards

Marco



Marco Lauria

STARMAX s.a.s.

TEL. +39-091-6880476

FAX +39-091-6887202

MOB. +39-348-3547034





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