Notifications (again)

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
LHSoft
Posts: 130
Joined: Sat 18 Aug 2012 08:33

Notifications (again)

Post by LHSoft » Mon 03 Jun 2013 10:22

Hello,
a table is set to get and send notifications, everything works fine unless there is a date in the SQL WHERE section, standalone or comined, f.x.
select * from MoStmKun WHERE day='03.06.2013'
.

So, in this case, I get errormessage: Statement does not support notifications, but indeed it still sends notifications but does not recieve.

Is this a bug or standard?

best regards
Hans

AndreyZ

Re: Notifications (again)

Post by AndreyZ » Mon 03 Jun 2013 13:29

The point is that notifications has several restrictions for the SELECT statement, you can find them here (in the "Supported SELECT Statements" section): http://msdn.microsoft.com/en-us/library ... l.90).aspx . Make sure, your SELECT statement meats all of notifications requirements.

Post Reply