🚀 go-pugleaf

Thanks for the response Peter,

But that isn't the case here.  I am changing the SQL on an existing,
working query at runtime.  If I change it to an SQL without the IN
keyword, it works.

Steve Pietrykoski

Peter Ayre wrote:
> 
> 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

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

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

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

>>   "select id from table1 where id  in (select id from table2)"
>>  "select id from table1 where id  not in ('01','02','03')"

I Did use these sql statements in multi-tier program.

Like the demo in CBuilder examples\midas\adhoc directory
I wrote the code like the following:

void __fastcall TForm1::RunButtonClick(TObject *Sender)
{
  // Send the query string to the server and try to open the client dataset
  ClientDataSet->Close();

  WideString wsql = "select id from table1 where id  in (select id from
table2)";
  // Bind to IDispatch of server and send SQL string over
  IAdHocQueryDemo_BCBDisp srvr;
  srvr.Bind(LPDISPATCH(RemoteServer->AppServer));
  srvr.SetSQL(wsql.Copy());

  // Open/Display the dataset
  ClientDataSet->Open();
}