Can you create another ADO recordset from another ADO recordset

Can you create another ADO recordset from another ADO recordset

Post by RHdpZ2h » Wed, 07 Apr 2004 19:21:02


H

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 thought

Dwigh
 
 
 

Can you create another ADO recordset from another ADO recordset

Post by Stephen Ho » Wed, 07 Apr 2004 20:09:54

> 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.

Have a look at the Clone() method

Stephen

 
 
 

Can you create another ADO recordset from another ADO recordset

Post by RHdpZ2h » Wed, 07 Apr 2004 21:31:04

Cheers!
 
 
 

Can you create another ADO recordset from another ADO recordset

Post by Miguel Mar » Thu, 08 Apr 2004 01:39:09

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

Best regards,

Miguel

"Dwight" < XXXX@XXXXX.COM > escribien el mensaje
>> 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 >> >>