Re: [dabo-users] multiple result sets. Is it possible?

El 02/03/12 20:24, Paul McNett escribió:

> On 3/2/12 2:58 PM, Ricardo Araoz wrote:

>> Let's say your large SQL statement has millions of rows and you want to

>> group those rows in one data set and you want a subset of those rows in

>> another data set. I'd rather recieve two datasets with 100 rows each

>> (and processed in the dbms) than several million rows in one dataset and

>> having to process it locally to obtain both final data set results.

> Python's dbapi provides for this with cursor.fetchmany(num_rows). Dabo does not

> provide for this as it stands, because we always do cursor.fetchall().

Wouldn't that be fetching sets of rows of the SAME data set?

What I need is to recieve two data sets from a single instruction.

query = """

select *

into #TempTable

from someBigTable

left join someOtherTable

on someConditions

where someRestraints

select someField, someOtherField, sum(someValue) as 'Total'

from #TempTable

group by someField, someOtherField

order by someField, someOtherField

select *

from #TempTable

left join #OtherTempTableFromSomeOtherPreviousQuery

on SomeConditions

where someOtherRestraints

"""

If I sent this query to the dbms from VFP I would recieve two cursors,

whose names would be by default (you may specify other) "cursor" and

"cursor1".

The "query" is defined by the user, so there is no way I may think of

better or worse strategies, I want to get two different data sets so

that I may later include them in a spread sheet or a csv file.

_______________________________________________

Post Messages to: Dabo-users@leafe.com