Property of TMSQu.Filter does not support bit operations?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Alexander_73
Posts: 52
Joined: Mon 24 Mar 2008 13:22

Property of TMSQu.Filter does not support bit operations?

Post by Alexander_73 » Wed 08 Apr 2009 13:13

Table with fields ID INT, Attributes INT. Field Attributes is sum of bit.

A component of TMSQuery with sql text:
SELECT ID, Attributes
FROM MyTable
WHERE Attributes & 1=1 - its work.

Then I write into property MSQuery.Filter: Attributes=1 - works.
Then I write Attributes&1=1 - raises error "Illegal filter expression"
Such expressions are not supported by the filter?

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

Post by Dimon » Thu 09 Apr 2009 07:48

No. The TMSQuery.Filter property does not support bit operations.

Post Reply