bfredrickson
asked on
Is it possible to query a disconnected recordset?
I have created and populated two disconnected ADO recordsets. I would like to query them and produce a third recordset. (This is temporary data, so saving it to SQL is just extra overhead). Is this even possible?
ASKER
Records range from 200 to 750,000. I'm hoping for a SQL type statement like: rDisconnRS3.Open "SELECT * FROM rDisconnRS1"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
bfredrickson:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
Experts: Post your closing recommendations! Who deserves points here?
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
Experts: Post your closing recommendations! Who deserves points here?
Moderator, my recommended disposition is:
Accept Sethi's comment(s) as an answer.
DanRollins -- EE database cleanup volunteer
Accept Sethi's comment(s) as an answer.
DanRollins -- EE database cleanup volunteer
Depending on the numbers of records that your talking about you could cycle through your recordsets and apply your logical criteria to them as you go. Then when something matched your criteria/query you could put that record into an array for later use. To cycle through the records use logic to the effect of:
Do until Rec.EOF=True
'See if record matches criteria
Next
If its too many records this may not be a desireable approach though. Anyway just an idea.
G