Hi Erik,

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

No.

> 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.

There's nothing in the system tables for that.

You could try firing events after updating the lookup tables so
your clients can refresh automatically.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com