Hi there,

> what I am looking for is to track what changes are being made by
> every transaction..say I have field "name" which has
> value "adam"..someone changes it to "adams2"..i want to be able to
> track in such a way that old as well as new value are stored in an
> audit table..

IB LogManager does exactly that.
http://www.upscene.com/products/audit/iblm_main.htm




--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2 (NEW!)
Upscene Productions
http://www.upscene.com