🚀 go-pugleaf

No, it cannot.

The MS docs for the ADO Filter property state the following:

There is no precedence between AND and OR. Clauses can be grouped within
parentheses. However, you cannot group clauses joined by an OR and then join
the group to another clause with an AND, like this:
(LastName = 'Smith' OR LastName = 'Jones') AND FirstName = 'John'
Instead, you would construct this filter as
(LastName = 'Smith' AND FirstName = 'John') OR (LastName = 'Jones' AND
FirstName = 'John')

Mark Guerrieri
CTO
Creative Marketing Strategies
mguerrieri@cmsgrp.com


"Baris YURTCU" <badidi@hotmail.com> wrote in message
news:3d278297_2@dnews...
> Hi,
>
> My record set object is dataset1. DB is MS-SQL server.
>
> dataset1.Filter = "Age <= 18 AND (Age = NULL OR Age >= 30)" // First Code
>
> This code doesn't work. But these codes work:
>
> dataset1.Filter = "(Age = NULL OR Age >= 30)" // Second Code
>
> dataset1.Filter = "Age <= 18 AND (Age = NULL AND Age >= 30)" // Third Code
>
> Change is only OR on third code according to first code. I have changed OR
> to AND. (Condition is nonsensical, but that's not important) Second code
> works fine.
>
> What this does mean? Can not ADO analyze "(<Condition1> AND <Condition2>
> (<Condition3> OR <Condition4>)" style Filter?
>
> Thanks,
> Baris
>
>