Article View: borland.public.cppbuilder.database.ado
Article #5140Re: Problems with filters
From: Jurko
Date: Tue, 24 Jul 2001 06:53
Date: Tue, 24 Jul 2001 06:53
27 lines
1596 bytes
1596 bytes
Something like...
dset->Filter = Format( "ColumnName < %d",
ARRAYOFCONST((Edit1->Text.ToIntDef(73945))) );
dset->Filtered = true;
HTH,
Jurko
"Stuart Gibb" <s_gibb2@hotmail.com> wrote in message
news:3b558af6$1_2@dnews...
>
> I am having difficulties with the filter property. I wish to filter a
dataset whereby only records where a field is less than or equal to an edit
box are displayed. An error message to the effect arithmetic operators not
recognised is displayed. How can this be avoided.
>
> This is the code I have been trying to use.
>
> UcasPoints->Filter <= Edit1->Text;
> or (Dataset1->Filter <= Edit1->Text;)
>
> Any tips greatly appreciated.
>
> Staurt Gibb.
>
>
Technical Details
Message-ID:
<3b5d1b7a$1_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!grolier!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnewsReferences:
<3b558af6$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,a7f3a4652bb78c41 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-07-23 23:55:04 PST Reply-To: "Jurko" <Jurko@ve-mil.hr> From: "Jurko" <Jurko@ve-mil.hr> Newsgroups: borland.public.cppbuilder.database.ado References: <3b558af6$1_2@dnews> Subject: Re: Problems with filters Date: Tue, 24 Jul 2001 08:53:55 +0200 Lines: 29 Organization: Ve-mil 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: 195.29.221.130 Message-ID: <3b5d1b7a$1_1@dnews> X-Trace: dnews 995957626 195.29.221.130 (23 Jul 2001 23:53:46 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!grolier!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews