Using a Recordset as a Data Source for a New Query and Resulting Recordset

From: Andrew <andrew@xxxxxxxxx>
Date: Wed, 16 Nov 2005 00:50:25 -0500

I have an ADO recordset (rs1) in memory and want to run a query off of it, creating a new ADO Recordset (rs2) containing a subset of the records from the original ADO Recordset (rs1). Would anyone be kind enough to provide a small code snippit in VB which would allow me to accomplish this?

Many thanks in advance ....


Andrew

Follow-Ups:
- Re: Using a Recordset as a Data Source for a New Query and Resulting Recordset
  - From: Stephen Howe

Prev by Date: Re: ADO Recordset Save as XML error
Next by Date: RE: datacolumn ; datatable in Visual Studio 2005 Beta 2
Previous by thread: ADO Recordset Save as XML error
Next by thread: Re: Using a Recordset as a Data Source for a New Query and Resulting Recordset
Index(es):
- Date
- Thread

Relevant Pages

Re: Using a Recordset as a Data Source for a New Query and Resulting Recordset
... So any update in clone affect original and vice versa. ... > Dim loCon As ADODB.Connection ... > Dim rs1 As ADODB.Recordset ... >>I have an ADO recordset in memory and want to run a query off of it, ...
(microsoft.public.vb.database.ado)
Re: Using a Recordset as a Data Source for a New Query and Resulting Recordset
... Dim loCon As ADODB.Connection ... Dim rs1 As ADODB.Recordset ... Dim rs2 As ADODB.Recordset ... >I have an ADO recordset in memory and want to run a query off of it, ...
(microsoft.public.vb.database.ado)
one recordset as input to another
... how can we create an ado recordset and then use it as input to ... For example, if we create RS1 at below, ... Set RS1 = New ADODB.Recordset ... Set RS2 = New ADODB.Recordset ...
(microsoft.public.vb.database)
one recordset as input to another
... how can we create an ado recordset and then use it as input to ... For example, if we create RS1 at below, ... Set RS1 = New ADODB.Recordset ... Set RS2 = New ADODB.Recordset ...
(microsoft.public.vb.database.ado)
Using a Recordset as a Data Source for a New Query and Resulting Recordset
... I have an ADO recordset (rs1) in memory and want to run a query off of it, creating a new ADO Recordset (rs2) containing a subset of the records from the original ADO Recordset. ...
(microsoft.public.vb.database.ado)