WHERE ... IN not supported?

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

2 messages

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

2 total messages Started by Bob Israel Tue, 11 Nov 1997 00:00

#12

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

Re: WHERE ... IN not supported?

#32

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

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