Subject Re: [firebird-support] Re: execute statement
Author Mark Rotteveel
On 9-8-2012 22:13, Sergio wrote:
>> EXECUTE STATEMENT is for executing queries only, your code is not just a
>> query as it contains an IF statement. I think for your purposes you need
> Thanks Mark!
> Yes... I've been reading it before, but I didn't found any example similar of what I want to do...
> Perhaps is no possible at all?

I think you need to create an EXECUTE BLOCK statement as text and then
execute that using EXECUTE STATEMENT, however I am not actually sure if
that would give you access to the NEW and OLD context tables.

> Anyway, I was "inspired" in a firebird FAQ

That is more an example of how you can use a query to write the trigger
code, but the result of that query will still be the normal code inside
the trigger.

Mark Rotteveel