Hi,

> I would Like to Log Changes in Specific Tables and some columns within
> those tables to preferably within same databases table or to some external
> file is also acceptable. format of log required is
>
> Date-Time at which change occurred, type of change insert, delete, edited,
> For each column OLD.Value - NEW.Value
> --- ---
> in a blob column.
>
> is there any free/commercial tool to do this ?

You could give IB LogManager a try. It's not free though.



Best Regards,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com