TMSChangeNotification question

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Zelius
Posts: 5
Joined: Tue 24 Aug 2010 10:28

TMSChangeNotification question

Post by Zelius » Wed 25 Aug 2010 12:33

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!

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 25 Aug 2010 14:06

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

Zelius
Posts: 5
Joined: Tue 24 Aug 2010 10:28

Post by Zelius » Wed 25 Aug 2010 14:37

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

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 26 Aug 2010 10:07

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.

Post Reply