Create ADO recordset from recordset

[LPent]

Hi,

Is it possible to create a recordset from another recordset in ADO?

I have one recordset named rstPrimary that contains "unknown" data. I do know however it contains a field called "[Type]" which can contain either the value "NEW" or "OLD". What I need is to split this recordset into 2 new recordsets one for each possible value of "[Type]".

 

[bjd4jc]

You could use the clone method and then filter each recordset on each of those filters.

 

[fredericofonseca]

And if you have two record types so well defined it may be better to have two recordsets created with two different SQL's in the first place



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[LPent]

You are probably right. Thanks for the input.