I was approaching the conclusion that this is expected behavior. Glad to have it confirmed with a reasonable explanation why. I guess the fix will be to document the behavior.<br><br>Thanks,<br>Michael Manfre<br><br><div class="gmail_quote">
On Fri, Jun 22, 2012 at 11:38 PM, Chris Lambacher <span dir="ltr"><<a href="mailto:chris@kateandchris.net" target="_blank">chris@kateandchris.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im"><br><br><div class="gmail_quote">On Wed, Jun 20, 2012 at 10:50 AM, Michael Manfre <span dir="ltr"><<a href="mailto:mmanfre@gmail.com" target="_blank">mmanfre@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>The observed behavior is equivalent to this bit of SQL.<br><br><blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote">DECLARE @retval int, @someOut int<br>
exec @retval = uspReturnsAResultSetOrTwo @someOut OUTPUT<br>SELECT @retval, @someOut<br></blockquote><div><br>I haven't been able to find any documentation stating that this is the intended behavior and this doesn't match my experience of using stored procedures with <a href="http://ADO.NET" rel="noreferrer" target="_blank">ADO.NET</a>. Is this expected behavior? Is there some combination of cursor types or attributes to get the output parameter values without fetching/skipping all the recordsets?<br>
</div></div></blockquote></div><br></div>This is the behaviour of the Microsoft's ADO library which is the underlying api that adodbapi works against. It is pretty hard to find docs for ADO because <a href="http://ADO.NET" target="_blank">ADO.NET</a> sucks up all the hits and Microsoft's own MSDN docs for ADO are pretty weak. Also, that is fundamentally the pattern you would use with ODBC too which does not have any particular notion of Stored Proceedures. ADO is based on ODBC connections so that may be the source of this particular behind the scenes idiom.<span class="HOEnZb"><font color="#888888"><div>
<br></div><div>-Chris</div><div><br>-- <br>Christopher Lambacher<br><a href="mailto:chris@kateandchris.net" target="_blank">chris@kateandchris.net</a><br>
</div>
</font></span></blockquote></div><br>