[python-win32] adodbapi and stored procedure output parameters on

Randy Syring randy at rcs-comp.com
Tue May 26 20:54:32 CEST 2009



Vernon Cole wrote:
> In this case, the proceedure outputs TWO record sets, since there are
> two SELECT statements.
> If the second select statement, "select @param = 10" were changed to
> "SET  @param = 10" then, I believe, the result
> would have been as expected.
>   
Vernon, thanks for your comments.

In SQL Server, there is no recordset output for:

    select @param = 10

its simply a variable assignment.  You can verify this by doing the 
following in a TSQL or Query Analyzer session:

    declare @param int
    select @param = 1

You should see that no resultset is returned.

> Having said all that, I ran Randy's test program using pywin32 v213 on
> Python 2.6 and Vista, and it ran correctly.
>   
Really!  I did a fresh install of 2.6 and win32 extensions on vista just 
to verify this and I still got an error.  Vernon, so you got a message 
from nose that two tests passed?  Can anyone else verify this?

--------------------------------------
Randy Syring
RCS Computers & Web Solutions
502-644-4776
http://www.rcs-comp.com

"Whether, then, you eat or drink or 
whatever you do, do all to the glory
of God." 1 Cor 10:31

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-win32/attachments/20090526/375a0374/attachment.htm>


More information about the python-win32 mailing list