Using the IN clase in a filter?

Thread View: borland.public.vdbase.data.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Dan Howard Tue, 09 Mar 1999 00:00

#175

Author: Dan Howard
Date: Tue, 09 Mar 1999 00:00

13 lines
779 bytes

Hello all,

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')"

TIA

Re: Using the IN clase in a filter?

#176

Author: Romain Strieff [TeamB]
Date: Tue, 09 Mar 1999 00:00

20 lines
968 bytes

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

Re: Using the IN clase in a filter?

#177

Author: Dan Howard
Date: Tue, 09 Mar 1999 00:00

26 lines
1245 bytes

Thanks Romain,

I had a feeling... 

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

Re: Using the IN clase in a filter?

#178

Author: Dan Howard
Date: Tue, 09 Mar 1999 00:00

30 lines
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
> --

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads