Filter = "ID in (...) " doesn't work....

Article View: borland.public.cppbuilder.database.ado

Article #5761

Back to borland.public.cppbuilder.database.ado Previous Next

#5761

From: Ray Parker
Date: Mon, 05 Feb 2001 20:41

9 lines
1369 bytes

I have a TADOTable created from a view in and SQL7 server db, and I can't
understand why a simple Filter (where clause) like "ID in (1)" doesn't work.
The exact string what I'm using is a legal 'where' clause, but when I set
'Filtered' to true, I get the error:

"Arguments are of the wrong type, are out of acceptable range, or are in
conflict with one another"

Any ideas?

Technical Details

Message-ID: <3a7f0fe9$1_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!propagator!news-in-austin.nuthinbutnews.com!feed2.newsfeeds.com!newsfeeds.com!news.bnb-lp.com!bornews.borland.com!dnews!209.218.206.102

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,171fb8a98c54c231,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-02-05 12:42:17 PST
Reply-To: "Ray Parker" <rparker@madoff.com>
From: "Ray Parker" <rparker@madoff.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Filter = "ID in (...) " doesn't work....
Date: Mon, 5 Feb 2001 15:41:06 -0500
Lines: 11
Organization: Bernard L Madoff Investment Securities
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 209.218.206.102
Message-ID: <3a7f0fe9$1_1@dnews>
X-Trace: 5 Feb 2001 12:41:13 -0800, 209.218.206.102
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!128.230.129.106!news.maxwell.syr.edu!propagator!news-in-austin.nuthinbutnews.com!feed2.newsfeeds.com!newsfeeds.com!news.bnb-lp.com!bornews.borland.com!dnews!209.218.206.102