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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])