Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 2
Joined: Mon 31 Aug 2009 04:31


Post by HRamin » Tue 25 May 2010 07:55


How can i get which field is changed by ChangeNotification component???


Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 25 May 2010 12:18

TMSChangeNotification is notified about any changes made in the resultset, and it does not get information about changed field.

You can specify that TMSQuery should be automatically refreshed when the underlying data on the server is changed. For this set the MSQuery.ChangeNotification property and the MSQuery.Options.ReflectChangeNotify property to True. To refresh a dataset quickly your table should contain a timestamp field to use the RefreshQuick method instead of Refresh.

Post Reply