Subject | RE: [firebird-support] Creating a Database History |
---|---|
Author | Sasha Matijasic |
Post date | 2008-02-07T09:18:24Z |
> > Something like this:I didn't know that, thanx for pointing it out.
> > execute statement 'select old.' || fieldname || ' from table_name
> where
> ...'
>
> This won't work.
>
> Using EXECUTE STATEMENT with a context variable (NEW or OLD)
> will never work, cause that's only available inside a trigger, not in a
> new statement
And if I needed something like original poster described I would definitely write triggers for each table separately or I would use your LogManager.
Sasha