How to do filtering

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

Article #366

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

#366

From: Khai Trinh
Date: Tue, 19 Sep 2006 23:06

16 lines
1282 bytes

Hi,

Here's part of my code:
line 1.  ADOQuery1->SQL->Text = "select x1,x2 from table1";
line 2.  ADOQuery1->Filtered = true;
line 3.  ADOQuery1->Filter = "Production";
line 4.  ADOQuery1->Active = true;

At line 4, I get the error below:
"Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another."

Production is a bit field in table1 of a SQL database.  Any help for solving this is greatly appreciated.

Thanks,
Khai

Technical Details

Message-ID: <4510780b$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,268b4c7dd301faa8,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Khai Trinh" <khai.trinh1@navy.mil>
Sender: "Khai Trinh" <khai.trinh1@navy.mil>
Reply-To: "Khai Trinh" <khai.trinh1@navy.mil>
Subject: How to do filtering
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 138.163.0.42     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <4510780b$1@newsgroups.borland.com>
Date: 19 Sep 2006 16:06:51 -0700
X-Trace: newsgroups.borland.com 1158707211 207.105.83.66 (19 Sep 2006 16:06:51 -0700)
Lines: 16
Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail