Using IN with query in a RDM

Article View: borland.public.cppbuilder.database.multi-tier

Article #1754

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1754

From: Steve Pietrykoski
Date: Tue, 29 Jun 1999 00:00

10 lines
897 bytes

Hello all,

In a query in a regular datamodule, I can use the SQL keyword IN (e.g.
"where state in ('NJ', 'CA')" ).  But when I create the same query in a
RDM and attach a provider to it, I receive the error "Capability not
supported" when I try to open a client dataset attached to that
provider.  Is there a way to make this work?

Thanks,
Steve Pietrykoski

Technical Details

Message-ID: <3779301D.8A5A1581@artisansoftware.com>

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: fcd2b,b3e9f1c7b851a475,start
X-Google-Attributes: gidfcd2b,public
From: Steve Pietrykoski <steve@artisansoftware.com>
Subject: Using IN with query in a RDM
Date: 1999/06/29
Message-ID: <3779301D.8A5A1581@artisansoftware.com>
X-Deja-AN: 495333748
Content-Transfer-Encoding: 7bit
Organization: Artisan Software, LLC
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier