Re: How to signal a program that a table has changed?

In article <2260_at_keele.keele.ac.uk>, csa09_at_seq1.keele.ac.uk (P. Singleton) writes:
> [...]
> If you polled the database, how would you tell whether a table has changed?

All of our data is timestamped. A client would check that the timestamp (of the row with the greatest timestamp, if it's a logging table) is different than what it remembers.

-- 
Frederick G. M. Roeber | CERN -- European Center for Nuclear Research
e-mail: roeber_at_cern.ch or roeber_at_caltech.edu | work: +41 22 767 31 80
r-mail: CERN/PPE, 1211 Geneva 23, Switzerland | home: +33 50 42 19 44