🚀 go-pugleaf

You can not mix AND and OR this way. From MSDN:

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')

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Jonathan Dumaresq" <jdumaresq@cimeq.qc.ca_nospam> �������/�������� �
�������� ���������: news:419d0030@newsgroups.borland.com...
> hi all,
>
> I just try to port my bde app to ado app.
>
> I have a problem with a filter that work on bde and now dosen't work and
> throw an exception.
>
> here the filter:
>
> filter = "[Date] >= '2004-11-18' AND [Date] < '2004-11-19' AND ([Local] =
> 'F102' OR [Local] = 'F103');
>
> If I only put AND  or OR between field no exeption are genereted. But if i
> mix both ..
>
> Arguments are incorrect type, out of authorized limit or in conflic.
>
>
> bcb6 sp4
> regards
>
> Jonathan
>
>