WHERE ... IN not supported?

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

Article #12

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

#12

From: Bob Israel
Date: Tue, 11 Nov 1997 00:00

11 lines
785 bytes

When attempting "SELECT * FROM tablexx WHERE columyy IN (val1,val2,val3)"
I get a "capability not supported" message.  This is using IB c/s 1.5
with Oracle 7.  Is it really true that this construct is not supported,
or is it done another way?  The statement that IntraBuilder refuses works 
fine in SQL+.

TIA,
Bob Israel
UW-Extension
rlisrael@facstaff.wisc.edu

Technical Details

Message-ID: <34689E36.6CDB@facstaff.wisc.edu>

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: 101d9a,f7e8471fd826b862,start
X-Google-Attributes: gid101d9a,public
From: Bob Israel <rlisrael@facstaff.wisc.edu>
Subject: WHERE ... IN not supported?
Date: 1997/11/11
Message-ID: <34689E36.6CDB@facstaff.wisc.edu>
X-Deja-AN: 288642556
Organization: UW-Extension, Cooperative Extension/Academic
Newsgroups: borland.public.intrabuilder.data.sql