ADO FILTER , BOOLEAN EXPRESSION

[Franklin Demont]

Hello ,

Testing ADO oRs:Field := cExpression

I found some difficulties :

oRS.FILTER := "FIRST='Jon' OR (Married=0 AND LAST LIKE 'D*')"// Accepted
oRS.FILTER := FIRST='Jon' OR Married=0 AND LAST LIKE 'D*'" // NOT ACCEPTED
oRS.FILTER := "(FIRST='Jon' OR Married=0) AND LAST LIKE 'D*'" // NOT ACCEPTED
oRS.FILTER := "LAST LIKE 'D*' AND FIRST='Jon' OR Married=0" // NOT ACCEPTED
oRS.FILTER := "LAST LIKE 'D*' AND (FIRST='Jon' OR Married=0)" // NOT ACCEPTED

Why is only the first expression accepted ? Espacially why the third or fifth not ?

It seems that only the first one is accepted , how do we know where to place ( and ) ?

Frank

[Marc Vanzegbroeck]

I had the same problem
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=35944

Here is the documentation of the filter
https://docs.microsoft.com/en-us/sql/ado/reference/ado-api/filter-property?view=sql-server-2017