ADO: "Auto-Inform" other users about data changes (CursorType := ctDynamic)
Posted on 2006-11-29
I'm developing a multi-user system based on a Delphi 7 client application and a central MS SQL 2005 server database.
Connection between the application and the database is estabished via ADO.
My wish is: data changes of one user should be visible to other users immediatley.
In this context the Delphi Online help suggests to set the ADODataSet's property CursorType := ctDynamic.
ctDynamic provides a dynamic cursor which supposedly shows data changes to other users (according to the Delphi Online Help).
My problem: It is just not working. I can change any data on Client X, but none of these changes are visible on the other clients (until I refresh the dataset manually).
I then did some researches here on EE just to find out that ADO is not supporting this "auto-inform" feature.
If this is correctt, I have two questions:
1. What does the ctDynamic setting really do?
2. Which approach/workaround would you take to inform other clients about datachanges?