Real-time notifications

[Eddie Shipman]

My application, written in Delphi using ADO via myODBC, runs in a multi-user
environment. But when another user modifies data in the database, another user
cannot see it until manually refreshing.

I want to make the refreshing automatic. I've tired refreshing all databases but it uses
so much resources. I want to refresh only modified tables on the database for one
user.

How can i do that ?

Interbase used to have what is called the IBEventAlerter where we could capture
events on the Interbase conenction. This used to be a way to setup multi-user environments that had thae above capability.