--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@...> wrote:

>
> Dimitry Sibiryakov wrote:
> > On 17 Jul 2006 at 21:23, TechVale - Gustavo wrote:
> >
> >
> >> May i retrieve the "new" and "old" field values using its field

name

> >> in a trigger ?
> >>
> >
> > No, you can't. And EXECUTE STATEMENT won't help.
> >
> >
> interesting...
>
> I thought EXECUTE STATEMENT could fit, never used it for this

prupouse,

> but do you mind to explain why it can't help ?

It won't return the OLD ** Values **, although in an AFTER trigger it
could certainly return the NEW Values (although that would be quite
pointless query considering you already have them at your fingers).

Adam