Article View: borland.public.cppbuilder.database.multi-tier
Article #1755Re: Using IN with query in a RDM
From: Peter Ayre
Date: Wed, 30 Jun 1999 00:00
Date: Wed, 30 Jun 1999 00:00
21 lines
1204 bytes
1204 bytes
When I get that message it usually means that I have forgotten to set the
database property of my query and am doing something that SQL server likes
but paradox(the default) does not.
Hope this helps
Peter
Steve Pietrykoski wrote in message
<3779301D.8A5A1581@artisansoftware.com>...
>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:
<7lckl1$r6a5@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3779301D.8A5A1581@artisansoftware.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: "Peter Ayre" <peterayre@nospam.enterprise.net> Subject: Re: Using IN with query in a RDM Date: 1999/06/30 Message-ID: <7lckl1$r6a5@forums.borland.com> X-Deja-AN: 495531864 References: <3779301D.8A5A1581@artisansoftware.com> Organization: Another Netscape Collabra Server User X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Newsgroups: borland.public.cppbuilder.database.multi-tier