Why can't use cursor.nextset() in adodbapi package?

[nightmarch]

Thank you Dennis!

You mean I should execute many select statement like this " rec =
crsr.fetchall() " ?
But the result is the same, still got the error like "... 'Current
provider does not support returning multiple recordsets from a single
execution.'..."


On Mon, 24 Jan 2005 17:00:39 GMT, Dennis Lee Bieber
<wlfraed at ix.netcom.com> wrote:
> On Mon, 24 Jan 2005 17:18:05 +0800, nightmarch <nightmarch at gmail.com>
> declaimed the following in comp.lang.python:
> 
> > >>> sql = "select * from wjtmp"
> > >>> crsr.execute(sql)
> > >>> rec = crsr.fetchone()
> > >>> crsr.nextset()
> 
> > com_error: (-2147352567, '\xb7\xa2\xc9\xfa\xd2\xe2\xcd\xe2\xa1\xa3',
> > (0, 'ADODB.Recordset', 'Current provider does not support returning
> > multiple recordsets from a single execution.',
> > 'C:\\WINNT\\HELP\\ADO210.CHM', 0, -2146825037), None)
> >
> >
> >
> >
> > Why?
> >
> 
>         Could it be because you don't have multiple recordsets in crsr?
> 
>         You're executing a single select statement, retrieving the
> /first/ record from the result, and then trying to get a totally
> different result set.
> 
>         Maybe you want the next record in the record set you already
> have? crsr.fetchnext()?
> 
> > thanks
> 
> --
>  > ============================================================== <
>  >   wlfraed at ix.netcom.com  | Wulfraed  Dennis Lee Bieber  KD6MOG <
>  >      wulfraed at dm.net     |       Bestiaria Support Staff       <
>  > ============================================================== <
>  >           Home Page: <http://www.dm.net/~wulfraed/>            <
>  >        Overflow Page: <http://wlfraed.home.netcom.com/>        <
> --
> http://mail.python.org/mailman/listinfo/python-list
>