-
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.
-
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.
>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|