Using paramaters with MIDAS 2 Tier App

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

2 messages

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

2 total messages Started by Ross McLeod Fri, 10 Sep 1999 00:00

#1445

Author: Ross McLeod
Date: Fri, 10 Sep 1999 00:00

14 lines
931 bytes

Hi,

I am using MIDAS technology in a 2 tier application. When using a TQuery
with parameters I can't seem to set these via the TClientDataSet. I have
tried:

ClientDataSet->Params->Items[...]->Value = ...
ClientDataSet->Provider->SetParams (...)

The only way I can get this to work seems to be by passing the
parameters directly to the Query. Ideally I would like to avoid this.
Can anybody help?

Ross McLeod

Re: Using paramaters with MIDAS 2 Tier App

#1541

Author: Rabeh Mansour
Date: Fri, 24 Sep 1999 00:00

28 lines
1462 bytes

try this :

  ClientDataSet1->Close ();
  TParam*  param = new TParam (ClientDataSet1->Params,ptInput);
  param->Name = "CustNo"; // the parameter in the query is "CustNo"
(integer, input)
  param->DataType = ftInteger;
  ClientDataSet1->Params->AddParam (param);
  ClientDataSet1->Params->Items[0]->AsInteger = 1221;
  ClientDataSet1->Open ();

Ross McLeod <ross@mmp.com.au> wrote in message
news:37D85506.7A196FCB@mmp.com.au...
> Hi,
>
> I am using MIDAS technology in a 2 tier application. When using a TQuery
> with parameters I can't seem to set these via the TClientDataSet. I have
> tried:
>
> ClientDataSet->Params->Items[...]->Value = ...
> ClientDataSet->Provider->SetParams (...)
>
> The only way I can get this to work seems to be by passing the
> parameters directly to the Query. Ideally I would like to avoid this.
> Can anybody help?
>
> Ross McLeod
>

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