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?
Property of TMSQu.Filter does not support bit operations?
-
Alexander_73
- Posts: 52
- Joined: Mon 24 Mar 2008 13:22