> I'm trying to create a new trigger from INSIDE the database, into a
> procedure using the EXECUTE STATEMENT
>
> I create a string with all the syntax (really only a command)
>
> EXECUTE STATEMENT
> 'CREATE TRIGGER TRIAL_TRIGGER for TABLE1 '||
> 'AFTER INSERT '||
> 'POSITION 100 '||
> 'AS BEGIN '||
> 'EXECUTE PROCEDURE MY_PROCEDURE; '
> 'END';
>
> but when I try I get an ERROR.. very confusing, I think in semicolon.
>
> Any idea to do or really not possible to do?

Ey, back again :-)

I'll ask again, WHAT error are you getting?

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