Board index » delphi » Change Log

2005-11-22 04:52:24 PM
delphi20
I would like to to know how to write a query (and what to query) to find
out when a specific table was last changed. How it was changed would be
a good thing as well. Seems like the system tables should have this
information.
Can anyone provide a sample?
Thanks.
 

If you want to keep an audit trail or something like that, you might
want to investigate our "IB LogManager" product - see www.upscene.com
--
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
www.upscene.com
Database development questions? Check the forum!
www.databasedevelopmentforum.com
 

Ultimately, the only way to do this is via creating an ON UPDATE trigger
for the table in question.
John Abot writes:

Thank you both. I always like to make certain there isn't an easier
more obvious already worked out solution before I go off and do my own.
Trigger it shall be.