Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
- Posts: 104
- Joined: Sat 18 Aug 2012 08:33
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?
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.