> > Don't do that. SET TERM is only needed by client applications,
> > not by Firebird.
>
> I have same/similar problem without "SET TERM"
>
> you can try
>
> > > EXECUTE STATEMENT
> > > 'CREATE TRIGGER TRIAL_TRIGGER for DATATABLE '||
> > > 'AFTER INSERT'||
> > > 'POSITION 100 '||
> > > 'AS BEGIN '||
> > > 'EXECUTE PROCEDURE MY_PROCEDURE; '||
> > > 'END'
>
> you get an error (I think at semi-colon)

WHAT error?

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com