Stored Procedures and the Name of the Return Value


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Stored Procedures and the Name of the Return Value

Hybrid View

  1. #1
    John Canny Guest

    Stored Procedures and the Name of the Return Value


    Hi Rob
    My question is on the return value from a stored procedure that is executed
    through ADO

    Executing a stored procedure through ADO, against a SQL 7.0 server, the name
    of the return value is ADODB.Command.parameters("RETURN_VALUE").

    The same code executed against a SQL 2000 server, the name of the return
    value is now ADODB.Command.parameters("@RETURN_VALUE").

    Is there a way to have SQL Server 2000 use the name RETURN_VALUE instead?

    Thanks
    John C.

    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: Stored Procedures and the Name of the Return Value

    I hadn't run across this particular problem, and I can't seem to replicate
    it.

    As long as I define the return value parameter as being of direction
    adParamReturnValue and create it first in the collection, I have no problem
    with it at all.

    Can you post some sample code on this one?


    --
    Rob Vieira
    Visit www.ProfessionalSQL.com Today. It's new and improved!


    "John Canny" <johncanny@hotmail.com> wrote in message
    news:3a6dd922$1@news.devx.com...
    >
    > Hi Rob
    > My question is on the return value from a stored procedure that is

    executed
    > through ADO
    >
    > Executing a stored procedure through ADO, against a SQL 7.0 server, the

    name
    > of the return value is ADODB.Command.parameters("RETURN_VALUE").
    >
    > The same code executed against a SQL 2000 server, the name of the return
    > value is now ADODB.Command.parameters("@RETURN_VALUE").
    >
    > Is there a way to have SQL Server 2000 use the name RETURN_VALUE instead?
    >
    > Thanks
    > John C.
    >



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center