[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