Subject Re: possible to CREATE a TRIGGER from a INSIDE?
Author skander_sp
--- In Firebird-general@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

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