Do a select on an adodp recordset into another recordset

[LeanneGodney]

Hi there,

Do you know if it's possible to have a recordset (perhap a disconnected one) and be able to create another recordset based on a select of the first one?

i.e.

dim FirstRS as new adodb.recordset
firstrs.open "Select string",connection etc etc

Then I'd want to do something like this:

dim SecondRS as new adodb.recordset
secondrs.open "Select distinct TradeRef from firstrs", etc etc

Is this possible?

Thanks in advance,
Leanne

 

[cmmrfrds]

If you just need a subset of the records in the recordset you could filter then, do what you need and then reset the filter.

 

[LeanneGodney]

I would want to do a select distinct to get unique values from a particular field, for example. But I've wanted to do something like this before for other reasons and haven't been able to figure out how.

So I guess it's not possible then?

 

[cmmrfrds]

Right, you cannot use SQL on a recordset.

 

[LeanneGodney]

Thanks for letting me know! You're a great help cmmrfrds!

:0)

Leanne