Article View: borland.public.cppbuilder.database.multi-tier
Article #1620Re: Using IN with query in a RDM
From: Steve Pietrykoski
Date: Thu, 01 Jul 1999 00:00
Date: Thu, 01 Jul 1999 00:00
21 lines
1292 bytes
1292 bytes
Jim,
I'm sorry for not making myself clear. I can use IN in a query with no
problem in a two-tier app, but I cannot access a query using IN through
a provider in a *three-tier* app. Is this SQL against your paradox
table being accessed by a client dataset through a provider?
Steve Pietrykoski
Jim wrote:
>
> I used the statement before,but it worked.
> My SQL statement look like
> "select id from table1 where id in (select id from table2)" or
> "select id from table1 where id not in ('01','02','03')"
> All worked in paradox table.
>
> maybe you should show your entire sql statement or
> try your statement in Database Destop first.
>
> Jim
Technical Details
Message-ID:
<377B94F7.F96F8F23@artisansoftware.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3779301D.8A5A1581@artisansoftware.com> <7leenl$str3@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,b3e9f1c7b851a475 X-Google-Attributes: gidfcd2b,public From: Steve Pietrykoski <steve@artisansoftware.com> Subject: Re: Using IN with query in a RDM Date: 1999/07/01 Message-ID: <377B94F7.F96F8F23@artisansoftware.com> X-Deja-AN: 496068050 Content-Transfer-Encoding: 7bit References: <3779301D.8A5A1581@artisansoftware.com> <7leenl$str3@forums.borland.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: Artisan Software, LLC Mime-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier