Thank You all for Your help!

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> Hi,
>
> > I want to log every transaction on some tables, with one single

procedure.

> > The procedure will be called like this:
> > execute procedure naploz(<TABLENAME varchar(20)>,<TRANS.TYPE char

(1) -

> > 'I' for insert, 'u' for update, 'd' for delete>)
> > How can I retrieve the OLD.<FIELDNAME> and NEW.<FIELDNAME> values?
>
> You cannot. These are ONLY valid in a trigger.
>
> Instead of re-inventing the wheel on logging database changes, why
> not take a look at our database logging tool IB LogManager?
> www.upscene.com
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &

MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>