On Friday, March 02, 2012 3:24:58 pm Paul McNett wrote: > 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().
In Dabo could you not use a tempCursor to get the same result? http://paul.dabodev.com/doc/api/dabodoc/dabo.biz.dBizobj.dBizobj.html#Methods_getTempCursor > > Paul > 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]
