troubleshooting Question

ADO recordsets created in memory

Avatar of AndyAinscow
AndyAinscowFlag for Switzerland asked on
C++
5 Comments1 Solution1188 ViewsLast Modified:
I have the following situation where I create an ADO recordset in memory

crudely
ADO::_RecordsetPtr rs;
..
rs->Fields->Add("IntField",...);
rs->Fields->Add("TextField",...);

rs->Open();
rs->AddNew();
..
rs->Update();

Now I would like to create a similar recordset, call it rs2, and add records to it.  Both have an integer field which I would like to use to join the two sets together.  
(Think of a classical SQL statement SELECT TblA.TextField, TblB.TextField FROM TblA INNER JOIN TblB ON TblA.IntField= TblB.IntField ).

Remember I don't actually have any tables, just two recordsets constructed in memory.

So is it possible? and if so how?


ASKER CERTIFIED SOLUTION
clockwatcher

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros