Property of TMSQu.Filter does not support bit operations?
Posted: 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?
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?