Using the IN clase in a filter?

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

Article #175

Back to borland.public.vdbase.data.sql Previous Next

#175

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

Technical Details

Message-ID: <36E52BC6.9D3970DF@total.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,fc90135285354f1,start
X-Google-Attributes: gidff5a1,public
From: Dan Howard <sproket@total.net>
Subject: Using the IN clase in a filter?
Date: 1999/03/09
Message-ID: <36E52BC6.9D3970DF@total.net>
X-Deja-AN: 452975667
Content-Transfer-Encoding: 7bit
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