Client notification

[bfeuskirchen]

Hello,

i'm using Interbase 6 and like to know, if there is a possibility to tell all other clients that I've changed a table and that they should update their data (do automatical refresh). How can I do that?

Greetings,

Christian

 

[Oppenhiemer]

Hi Christian -

What development tool are you using to interact with Interbase, Delphi ? Or do you mean just by working with Interbase itself?

Either way I think you need to perhaps look at using "Events". These can be used in triggers and can broadcast certain events from the server. For example...

CREATE TRIGGER POST_NEW_ORDER FOR ORDERS
ACTIVE BEFORE INSERT POSITION 0
AS BEGIN
POST_EVENT "NEW_ORDER";
END

Anyway, hope this helps..

Opp.