Hi,

Take a look at the new "EXECUTE STATEMENT" in the release notes.

HTH,
Fabrice Aeschbacher

--- In firebird-support@yahoogroups.com, "lartz001" <rob@c...> wrote:
> If i want to make a trigger so that when I insert some data into a
> set table one of the fields will contain an sql query, I want to then
> execute that sql as a trigger.
>
> ie:
>
> insert into table (field1,sql1) values ('something', 'insert into
> sql_table (f1,f2,f3) values (\'a\',\'b\',\'c\')');
>
> then it would run the trigger for the insert into sql_table....
>
> if there is no easy way of doing it with a trigger then I could just
> code it into php,asp,cold fusion or what ever it will be done in.
>
> Any suggestions would be appreciated however