Article View: borland.public.cppbuilder.database.ado
Article #4561How to set parameters for TADOStoredProc?
From: sstar
Date: Thu, 29 Nov 2001 10:43
Date: Thu, 29 Nov 2001 10:43
36 lines
1848 bytes
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!dnewsShow 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