ADO event model question
Database
1
Posts
1
Posters
0
Views
1
Watching
-
I hope someone can help with this problem I am having... In our application, we have a situation where a grid is populating itself from a simple SQL SELECT statement. The grid must update in real time when data in the database is changed. Data in the database may be changed by any user sitting at any workstation. My question is: Is it possible to receive a recordset event when data is changed in the database, given that the data may be changed by another user with a different connection? All the documentation we have found indicates that events are fired when an application changes data in the recordset, rather than the underlying data in the database being changed. Is this correct? Many thanks in advance! Visit my website![^]