About ADOStoredProc

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

Article #5227

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

#5227

From: Formentz
Date: Fri, 22 Jun 2001 15:03

18 lines
1315 bytes

Hi all,
I am using ADO and MSDE,
and trying to execute a StoredProc whith one OUTPUT parameter, but can't get
it work :
1) if I set the ProcedureName by design, it adds ';1' string to the end of
the procedure name, why?
  If now I try to run it works well.
2) I set the ProcedureName at runtime without the ';1' at the end and the
error is :
Procedure 'StoredProc2' expects parameter '@testparm', which was not
supplied
3) then I thought I had to add the ';1' and the error is the same.

What did I do wrong?

TIA
Ciao
    Formentz

Technical Details

Message-ID: <3b335d66_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.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,931461ca7d9d6ea6
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-22 08:02:57 PST
From: "Formentz" <francesco@leotron.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: About ADOStoredProc
Date: Fri, 22 Jun 2001 17:03:41 +0200
Lines: 22
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: 62.122.27.250
Message-ID: <3b335d66_1@dnews>
X-Trace: dnews 993221990 62.122.27.250 (22 Jun 2001 07:59:50 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews