Re: Can a database notify all clients when something changes?

Satan Devil wrote:
> Suppose that there are 3 workstations connected to a
> central database. When Workstation A changes
> something, Workstation B and C must get the changes.

Not really clear what you are trying to accomplish.  The simple fact
that all 3 workstations are communicating with a central database means
that they all "get the changes".  Are you saying that B and C might be
displaying the old version of data that A has just changed, and you want
B and C to automatically see the updated values?  If that is what you
are after, then you'll need to do something application-wise.  What
application are these clients using to view data?  You can either (1)
broadcast changes entirely through your application, or (2) set up a
trigger in the database to kick off the notifications.  Depending on how
many changes you want to monitor, solution 2 might be burdensome (lots
of triggers.)

--
Guy Rouillier