Hi,

Is there a reliable way to determine in the system tables when a
table was last updated (INSERT or UPDATE action).

I am reading a Firebird 1.5 db from various clients using a Delphi
program and want to keep lookup-tables in memory until it can be
determined that one of the other clients has updated one of the
lookup tables (after which the relevant lookup table must be reread from db).

My first thought was to update a table myself from within the insert
and update triggers from the lookuptables ... but than I thought that
maybe that info can be retrieved from the system tables somehow.

Thanks in advance,
Erik