Subject Re: [firebird-support] Re: Retrieving field new and old value using variable
Author Helen Borrie
At 03:37 PM 18/07/2006, you wrote:

>So how do you do
>Where ID is the returned value in the current iteration of the for

You can't. I retract my comment about Alexandre's theory. It can't
work. FTR, triggers don't operate on SELECT statements so, even
assuming one had gone through an excruciating process of getting all
of the metadata info about each column, in order to construct a valid
DML statement, one would still be going through a revolving door of
recursion trying to perform an EXECUTE STATEMENT DML on the current row...