Re: WHERE ... IN not supported?

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

Article #32

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

#32

From: Raz
Date: Wed, 07 Jan 1998 00:00

21 lines
1078 bytes

Bob,

I encountered the same problem, but needed the dataset to be live.  I
just modified the SQL statement from fld IN('a','b') to fld = 'a' OR =
fld = 'b'.

Dave

Bob Israel wrote:
> 
> 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: <34B3EE07.EBFEB6A8@att.net>

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

References: <34689E36.6CDB@facstaff.wisc.edu>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,f7e8471fd826b862
X-Google-Attributes: gid101d9a,public
From: Raz <DMaziarz@att.net>
Subject: Re: WHERE ... IN not supported?
Date: 1998/01/07
Message-ID: <34B3EE07.EBFEB6A8@att.net>
X-Deja-AN: 313725525
Content-Transfer-Encoding: 7bit
References: <34689E36.6CDB@facstaff.wisc.edu>
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.intrabuilder.data.sql

Reply to Parent Message