Subject | Re: possible to CREATE a TRIGGER from a INSIDE? |
---|---|
Author | skander_sp |
Post date | 2005-10-27T13:22:05Z |
--- In Firebird-general@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
you can try
<m.tonies@u...> wrote:
> Don't do that. SET TERM is only needed by client applications,I have same/similar problem without "SET TERM"
> not by Firebird.
you can try
> > EXECUTE STATEMENTyou get an error (I think at semi-colon)
> > 'CREATE TRIGGER TRIAL_TRIGGER for DATATABLE '||
> > 'AFTER INSERT'||
> > 'POSITION 100 '||
> > 'AS BEGIN '||
> > 'EXECUTE PROCEDURE MY_PROCEDURE; '||
> > 'END'