On Friday, March 02, 2012 3:57:30 pm Ricardo Araoz wrote: > 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. >
Exactly. This is not VFP so it will require a different set of glasses:) In Dabo you can work with multiple DataSets, just in a different manner. More detail see: http://wiki.dabodev.com/DataSet Just substitute DataSet for TempTable. -- Adrian Klaver [email protected] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
