Subject Re: Triggers
Author Fabrice Aeschbacher

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

Fabrice Aeschbacher

--- In, "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