Right. There are a lot of triggers to maintain. A very "transparent"
solution for this problem is my product IBLogManager. This is a
very reliable and user-friendly data logging solution.

IB LogManager logs data changes in the database for each possible
data manipulation operation (Delete/Insert/Update) on specific database
objects(tables, columns). IB5.x/IB6.x/FB1.x support, operation-logging,
column-logging, BLOB-logging, reusable logging definitions,
logdata export, logdata report and many more...

Give it a try. A fully functional 30-days trial version is available from my
web site http://www.iblogmanager.com

If you have any questions, feel free to contact me directly.
ts@...

Best Regards
Thomas Steinmaurer
IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

""pkh2001fi"" <petter.holmstrom@...> schrieb im Newsbeitrag
news:a1pvf7+mg7b@......

> Hello,
>
> I need some kind of modification recording for every table. A user
> must be able to see who last edited a certain record in a certain
> table, and when. I was thinking of placing edited and editedby fields
> in every table and then use UPDATE and INSERT triggers to update the
> data. The problem is that there will be a huge number of triggers if
> I do so. Are there any other options?
>
> Thanks,
>
> -Petter-
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>