Re: How to do filtering

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

Article #368

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

#368

From: Viatcheslav V. Vassiliev
Date: Wed, 20 Sep 2006 07:23

32 lines
2138 bytes

In addition, if you filter using column Production, it should be in select, 
i.e. x1 or x2 should be Production.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Khai Trinh" <khai.trinh1@navy.mil> �������/�������� � �������� ���������: 
news:4510780b$1@newsgroups.borland.com...
>
> 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: <4510ec6d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!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
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4510780b$1@newsgroups.borland.com>
Subject: Re: How to do filtering
Date: Wed, 20 Sep 2006 11:23:18 +0400
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Antivirus: avast! (VPS 0638-0, 19.09.2006), Outbound message
X-Antivirus-Status: Clean
NNTP-Posting-Host: 85.93.138.132
Message-ID: <4510ec6d$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1158737005 85.93.138.132 (20 Sep 2006 00:23:25 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message