There are several ways for doing that.
One of them, is to create a table, called CHANGES, by example, and with the
columns: TABLENAME, USERNAME, DATEANDTIME, etc.
Then, for each table of your interest, you create a trigger which inserts a
row in the table CHANGES when a user do an INSERT,
Hi,
You can also look at sample at
http://itstop.pl/pl-pl/porady/Firebird/FAQ1/czas-ostatniej-modyfikacji-tabeli
It is in PL lang but triggers are fully descriptive. I prefer generator based
approach
Regards,Karol Bieniaszewski
null
Hi,
Look at System Audit feature.
Regards,
Alexey Kovyazin
IBSurgeon HQbird
www.ib-aid.com
On 09.10.2017 2:49, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
Is there an official way to detect if a database has changed?
I have some expensive reports and backups to run,
Is there an official way to detect if a database has changed?
I have some expensive reports and backups to run, but if I know that the
database has not changed since I last ran them I can skip those.
fbstat (gstat) shows the next transaction number, but that changes even
when only read-only