I'm working with Delphi 4 C/S.
I could have posted this question on the Delphi side, but, as I think this is more related to MS SQL and it should be a general procedure, I did it here.
I've got an operator application running against MS SQL Server, where multiple operators can be changing tables that other operators can be using at the same time. Those that are using the updated tables cannot see the updates, but might need to use them.
What is the mechanism to make the Server to notify the clients applications that something has changed on the database, so that the client application can refresh its data and work with the most recent data?
The kind of solution I'm thinking of, is a mechanism similar to the Interbase triggers/POST_EVENT solution. With this, for each table, I write a trigger that posts an event to the application when this "registers interest" in that event.
I know that triggers are available on MS SQL 6.5, but I don't arrive to understand the whole thing. If can send me an example, it will be wonderful.
Thanks a lot.