Re: How to do filtering

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

Article #367

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

#367

From: Bob Swart
Date: Wed, 20 Sep 2006 06:39

30 lines
1877 bytes

Hi Khai,

> 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;

Change it as follows:

ADOQuery1->SQL->Text = "select x1,x2 from table1";
ADOQuery1->Active = true;
ADOQuery1->Filter = "Production = 1"; // for example
ADOQuery1->Filtered = 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."

It's about the filter expression - it's not an expression.

> Thanks,
> Khai

Groetjes,
           Bob Swart

-- 
Bob Swart Training & Consultancy (eBob42.com)  Forever Loyal to Delphi
Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
New Delphi 2006 Courseware e-books at http://www.eBob42.com/courseware

Technical Details

Message-ID: <4510E22D.9070900@chello.nl>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <4510780b$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,268b4c7dd301faa8
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Message-ID: <4510E22D.9070900@chello.nl>
Date: Wed, 20 Sep 2006 08:39:41 +0200
From: Bob Swart <b.swart@chello.nl>
Organization: Bob Swart Training & Consultancy (eBob42)
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: How to do filtering
References: <4510780b$1@newsgroups.borland.com>
In-Reply-To: <4510780b$1@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 212.187.74.50
X-Trace: newsgroups.borland.com 1158734382 212.187.74.50 (19 Sep 2006 23:39:42 -0700)
Lines: 30
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newshub.sdsu.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message