[DB-SIG] Database API clarifications

[Ted Horst]

Multiple result sets are commonly returned from stored procedures, but you  
can also send multiple select statements at one time.  My noncompliant  
sybase module always returns a list of result sets (although there is  
usually only only item in the list).

Ted Horst
(not speaking for any current or future Swiss Bank)

You wrote:
> Tod Olson wrote:
> >
> > >>>>> "B" == Bill Tutt <billtut@microsoft.com> writes:
> >
> > B> Generally the way to do this is just to have a seperate
> > B> getNextResult() API call that you call when your first result set
> > B> fetch*() calls return None.
> >
> > So the next question to the SIG: should this mechanism (or some other)
> > for handling multiple result sets be included in the database API?
> >
>
> Could you explain how you define multiple result sets with one
> SQL statement ? I'm not sure whether a cursor method is the right
> thing to add. Also, most DBs probably don't support this feature,
> so it should be optional from the APIs point of view.
>
> --
> Marc-Andre Lemburg
>
>
> _______________
> DB-SIG  - SIG on Tabular Databases in Python
>
> send messages to: db-sig@python.org
> administrivia to: db-sig-request@python.org
> _______________

_______________
DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org
_______________