Recordsets

From: Daryl (stockd_at_tpg.com.au)
Date: 12/31/03 

Date: Wed, 31 Dec 2003 09:20:51 +1000

Is it possible to create a standalone ADO recordset and populate it with the
contents of another recordset so it can have a filter applied to it.

My aim was to then use this recordset to allow the user to step through it
i.e. for use with a 'Find' feature, when the user wants the next record
meeting the their criteria then the primary key of the record in the
filtered recordset is used to show the record in the original recordset.
The original recordset is linked to a form for viewing.

Any idea would be good.

Thanks
daryl

Relevant Pages

  • Re: Copy Data from one ADO recordset to Another ...
    ... Why not first insert the records into a temp table ... > Clone will not work for my case. ... I would like to have a copy of that data in a disconnected recordset ... >> Cloning allows you to have a copy of your original recordset so that you ...
    (microsoft.public.vb.database.ado)
  • Re: Copy Data from one ADO recordset to Another ...
    ... Clone will not work for my case. ... updatable because it was built off a Stored Procedure that contains multiple ... I would like to have a copy of that data in a disconnected recordset ... > Cloning allows you to have a copy of your original recordset so that you ...
    (microsoft.public.vb.general.discussion)
  • Re: Copy Data from one ADO recordset to Another ...
    ... Why not first insert the records into a temp table ... > Clone will not work for my case. ... I would like to have a copy of that data in a disconnected recordset ... >> Cloning allows you to have a copy of your original recordset so that you ...
    (microsoft.public.vb.general.discussion)
  • Re: Copy Data from one ADO recordset to Another ...
    ... Clone will not work for my case. ... updatable because it was built off a Stored Procedure that contains multiple ... I would like to have a copy of that data in a disconnected recordset ... > Cloning allows you to have a copy of your original recordset so that you ...
    (microsoft.public.vb.database)
  • Re: Copy Data from one ADO recordset to Another ...
    ... Why not first insert the records into a temp table ... > Clone will not work for my case. ... I would like to have a copy of that data in a disconnected recordset ... >> Cloning allows you to have a copy of your original recordset so that you ...
    (microsoft.public.vb.database)