At 11:04 PM 1/08/2004 +0000, you wrote:

>i have a BeforeInsert trigger with this lines in it...
>
> G = 'CREATE GENERATOR "SAL_' || NEW.MOS_ID || '"';
> EXECUTE STATEMENT G ;
>
>when i insert a new record and this lines are fired i have no
>problems with IBManager but when i insert it in my application i
>have a "Connection Lost" error...
>
>What could be?? some Transaction Configuration ???? should i move
>this lines to the AfterInsert Trigger ???

You should remove this processing altogether from the trigger. Using
EXECUTE STATEMENT to create metadata is unsafe even in stored procedures
but, in a trigger, it is a bomb waiting to go off.

See my response to your question in firebird-support.

Helen