Randy: I am no longer employed by the company who supplied the SQL server I used to test on, and am stuck with SQLexpress on my laptop. No Query Analyzer. (Bah!) Clearly, either my test was invalid, or there is a difference in SQL versions. What version are you using? -- Vernon
On Tue, May 26, 2009 at 12:54 PM, Randy Syring <ra...@rcs-comp.com> wrote: > > > 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 > _______________________________________________ python-win32 mailing list python-win32@python.org http://mail.python.org/mailman/listinfo/python-win32