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

Author: Ricardo Araoz

Posted: 2012-03-02 at 16:31:42

El 02/03/12 19:09, Ed Leafe escribió:

> On Mar 2, 2012, at 4:06 PM, Ricardo Araoz wrote:

>

>> I need to send a user defined query to the dbms and recieve more than

>> one result set. In fox I would send the query and recieve "cursor",

>> "cursor1", ..., "cursorN".

>> Is that possible?

> I'm not sure I understand. Do you mean some sort of pagination of results? It sounds like you want to send one query and receive multiple result sets. That seems confusing to me.

Let's say I have a really complex and time consuming set of queries that

result in a temp table in the dbms. Now I want to get a couple of

different views of this data, say I want a subset of this result table

grouped and another subset in detail. So I obviously don't want to do

these queries twice to get both data sets.

I feel I'm not being clear. Bottom line, I want to send in one query two

or more selects and recieve from the dbms two or more result sets.

_______________________________________________

Post Messages to: Dabo-users@leafe.com

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/4F514A4E.4020301@gmail.com

©2012 Ricardo Araoz