Devart Forums

Hello!
I have created TMSQuery object with SQL = 'SELECT * FROM v_Tasks_My'
and create and assign TMSChangeNotification object. When i start program notification event raised immediately, if i try to refresh dataset it raised again. What should i do? How does it work?
Thanks!

You can see how to work with TMSChangeNotification in the ChangeNotification demo of SDacDemo.
Please, specify exact steps to reproduce the problem.

There are alright, just too many restrictions for supported statements.

The TMSChangeNotification component is used to register queries with the database and receive notifications in response to DML or DDL changes on the objects associated with queries.
The Query Notifications is SQL Server mechanism and this component implements the functionality of SQL Server.