Re: Can you create another ADO recordset from another ADO recordset

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Miguel Marzano (mmarzano_at_interfaces.com.ar)
Date: 04/06/04


Date: Tue, 6 Apr 2004 13:39:09 -0300

You can use hierarchical recordsets too, by means od the ADO Shape command.

Best regards,

Miguel

"Dwight" <anonymous@discussions.microsoft.com> escribió en el mensaje
news:D349D7C6-2039-40C5-B9A8-0615787E8EF5@microsoft.com...
> Hi
>
> Can anyone tell me if you can create a ADO subset recorset (in VB) from
another ADO recordset.
>
> For example, if I create a list of orders from a table into a recordset, I
would like to create a list of the customers who made these orders into
another recordset.
>
> Any thoughts
>
> Dwight
>
>



Relevant Pages

  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)
  • Re: DAO to ADO Recordset Options
    ... DAO was really fast when dealing with Access data (faster than ADO) but was ... Recordset. ... For client-sided cursors, there is only Static cursor type regardless as ... determines how often data is fetched from the server. ...
    (microsoft.public.data.ado)
  • Re: Is ADO Dead (3)?
    ... The Design of ADO ... ADO uses a single object, the Recordset, as a common representation for ... a forward-only stream of results from a database, ... where data is updated at the data source or cached locally as with the ...
    (comp.databases.ms-access)