Article View: borland.public.vdbase.data.sql
Article #178Re: Using the IN clase in a filter?
From: Dan Howard
Date: Tue, 09 Mar 1999 00:00
Date: Tue, 09 Mar 1999 00:00
30 lines
1353 bytes
1353 bytes
For any lurkers:
Solution:
rowset.parent.sql := ;
"select * from customer.dbf where ctyp_id IN ('00001','00002')"
Works wonderfully fast.
"Romain Strieff [TeamB]" wrote:
>
> In article <36E52BC6.9D3970DF@total.net>, Dan Howard politely paraphrased
> ...
> >
> > Is this possible? I was under the impression that the rowet.filter
> > statement was equvalent to the WHERE clause of an SQL statement. I've
> > tried:
> >
> > rowset.filter = "ctyp_id IN '00001','00002'"
> >
> > and
> >
> > rowset.filter = "ctyp_id IN ('00001','00002')"
> >
> alas not.
> --
> Romain Strieff [TeamB]
> Please read this newsgroup guide below before
> posting on the private Inprise newsgroups.
> http://www.inprise.com/newsgroups/guide.html
> --
Technical Details
Message-ID:
<36E53803.E09BE7A4@total.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<36E52BC6.9D3970DF@total.net> <MPG.114f4bcd649ba67998a016@forums.inprise.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,fc90135285354f1 X-Google-Attributes: gidff5a1,public From: Dan Howard <sproket@total.net> Subject: Re: Using the IN clase in a filter? Date: 1999/03/09 Message-ID: <36E53803.E09BE7A4@total.net> X-Deja-AN: 452994041 Content-Transfer-Encoding: 7bit References: <36E52BC6.9D3970DF@total.net> <MPG.114f4bcd649ba67998a016@forums.inprise.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: Another Netscape Collabra Server User Mime-Version: 1.0 Newsgroups: borland.public.vdbase.data.sql