🚀 go-pugleaf

the ADO Filter property does not support the NOT clause. Also,  you should
use single quotes around character literals. See

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdprofilter.asp

for full Filter support docs.

To get around this, write an OnFilterRecord (?) handler to filter records on
any criteria you desire.

Mark Guerrieri
mguerrieri@cmsgrp.com

"Farrokh Ghani Zadegan" <fghz@toosashena.com> wrote in message
news:3dfb71ef@newsgroups.borland.com...
> Hi!
>
> I'm using BCB6, ADO (Microsoft OLE 4.0 Provider), and MS Access database,
> and receive an error message when I apply the following filter to a table:
>
> TextFieldName NOT LIKE "%abc%"
>
> The error message sais:
>
> "The application is using arguments that are of the wrong type, are out of
> acceptable range, or are in conflict with one another."
>
> The strange point is that the filter:  (TextFieldName LIKE "%abc%")  works
> correctly on the same table and set of fields.
>
> Please tell me if you know any workaround for this problem.
>
> Thank you in advance,
> Farrokh
>
>