Re: Using paramaters with MIDAS 2 Tier App

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

Article #1541

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

#1541

From: 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
>

Technical Details

Message-ID: <7si006$n351@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <37D85506.7A196FCB@mmp.com.au>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,c72f9a981db7b4fd
X-Google-Attributes: gidfcd2b,public
From: "Rabeh Mansour" <khkhaifa@netvision.net.il>
Subject: Re: Using paramaters with MIDAS 2 Tier App
Date: 1999/09/24
Message-ID: <7si006$n351@forums.borland.com>
X-Deja-AN: 529347780
References: <37D85506.7A196FCB@mmp.com.au>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Organization: Another Netscape Collabra Server User
X-MSMail-Priority: Normal
Newsgroups: borland.public.cppbuilder.database.multi-tier

Reply to Parent Message