🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4561

How to set parameters for TADOStoredProc?

#4561
From: sstar
Date: Thu, 29 Nov 2001 10:43
36 lines
1848 bytes
My procedure is as below:
CREATE OR REPLACE PROCEDURE BillLogin(
    sProvider OUT Admins.provider_no %TYPE)
AS
BEGIN
    SELECT provider_no
    INTO sProvider
    FROM Admins
    WHERE admin_id = 'test'
END;

I'm sure the result is one row only

My codes are as below:
if(!ADOConnection1->Connected)
{
    this->ADOConnection1->Open();
}
ADOStoredProc1->ProcedureName = "BillLogin";

ADOStoredProc1->Parameters->Clear();
ADOStoredProc1->Parameters->AddParameter();
ADOStoredProc1->Parameters->Items[0]->DataType = ftString;
ADOStoredProc1->Parameters->Items[0]->Direction = pdOutput;
ADOStoredProc1->Parameters->Items[0]->Name = "sProvider";

ADOStoredProc1->ExecProc();
Edit1->Text = VarToStr(ADOStoredProc1->Parameters->Items[0]->Value);


When I run the exe file, I receive error message:
"Parameter object is defined incorrectly. Inconsistant or incompleted
information is provided."


Can anyone tell me how to set patameters for TADOStoredProc?
Technical Details
Message-ID: <3c061130$1_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,abbdc80ef399d86b,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-11-29 02:44:17 PST
From: "sstar" <s142857@21cn.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to set parameters for TADOStoredProc?
Date: Thu, 29 Nov 2001 18:43:29 +0800
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 203.93.240.102
Message-ID: <3c061130$1_2@dnews>
X-Trace: dnews 1007030576 203.93.240.102 (29 Nov 2001 02:42:56 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!uunet!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews