recordset in a recordset

From: Patrick Joyal <please.reply_at_to.the.newsgroup>
Date: 2000/05/19
Message-ID: <39254f91@news>#1/1

Hi,

I'm currently optimising an application in VB using ADO w/ Oracle OLE DB.

the SQL query below work fine, when used through ADO it returns a recordset where each row
contains columns from the header table (tmpFunctions) and one column is an other recordset containing the detail (tmpOperations) associated to each header.

My question is : Is it possible to build a stored procedure that returns a recordset containing a recordset as one of it columns ?

thanks

Patrick

SHAPE

     Select tmpFunctions.Function, tmpFunctions.Days,
            tmpFunctions.Contractor, MA_Contractors.Name,
            tmpFunctions.Minutes_Per_Unit , tmpFunctions.Cost
       From
      tmpFunctions,
         MA_Contractors
     Where tmpFunctions.Contractor = MA_Contractors.Contractor(+)
       and TaskId = gTaskIDH

} AS cmdReportOperations

APPEND
  (
    {
    Select tmpOperations.Operation, MA_Operations.Description, tmpOperations.Type, tmpOperations.Rate_Per_Minute,

            tmpOperations.Function
      From
     tmpOperations,
        MA_Operations
      Where tmpOperations.Operation = MA_Operations.Operation(+)
        And TaskId = gTaskIDH

} AS cmdReportOperationsDetails

RELATE 'Function' TO 'Function') AS cmdReportOperationsDetails Received on Fri May 19 2000 - 00:00:00 CDT