Article View: borland.public.cppbuilder.database.ado
Article #3080ADOTable Filter & NOT LIKE '%.....%' Problem!
From: Farrokh Ghani Zadegan
Date: Sat, 14 Dec 2002 17:19
Date: Sat, 14 Dec 2002 17:19
19 lines
1474 bytes
1474 bytes
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
Technical Details
Message-ID:
<3dfb71ef@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,b078c112a455d4f5,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-12-14 10:03:12 PST From: "Farrokh Ghani Zadegan" <fghz@toosashena.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: ADOTable Filter & NOT LIKE '%.....%' Problem! Date: Sat, 14 Dec 2002 09:19:38 -0800 Lines: 21 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 213.19.157.18 Message-ID: <3dfb71ef@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1039888879 213.19.157.18 (14 Dec 2002 10:01:19 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail