Re: TADOStoredProc

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

Article #2684

Back to borland.public.cppbuilder.database.ado Previous Next

#2684

From: Michael
Date: Mon, 07 Apr 2003 09:35

25 lines
2046 bytes

SP1->ProcedureName = "spAddCustomer";
file://Use folowing code before first-time used parameter:
SP1->Parameters->Refresh();
file://and after
SP1->Parameters->ParamByName("@CustNo")->Value = 3;
file://Write
SP1->Prepared = true;

"Tracy Stevens" <eat@joes.com> �������/�������� � �������� ���������:
news:3e8dae6e@newsgroups.borland.com...
> I'm having a little trouble using TADOStoredProc.  I don't think I've even
> accessed a parameter in the stored procedure.  My first attempts were:
>
>    SP1->ProcedureName = "spAddCustomer";
>    SP1->Parameters->ParamByName("@CustNo")->Value = 3;
>    SP1->Active = true;
>
> I keep getting SP1 "@CustNo" parameter not found.  But it is a parameter
of
> the stored procedure.
>
> I am using C Builder 5 and MS SQL Server Personal edition.
> Thank you.
>
>

Technical Details

Message-ID: <3e91464b@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e8dae6e@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,142474374a48ee3a
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-04-07 02:39:56 PST
Reply-To: "Michael" <moonmike@pisem.net>
From: "Michael" <moonmike@pisem.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3e8dae6e@newsgroups.borland.com>
Subject: Re: TADOStoredProc
Date: Mon, 7 Apr 2003 13:35:27 +0400
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 62.141.68.180
Message-ID: <3e91464b@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1049708107 62.141.68.180 (7 Apr 2003 02:35:07 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!38.144.126.75.MISMATCH!feed1.newsreader.com!newsreader.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!colt.net!peernews3.colt.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message