Link to home
Get AccessLog in
Avatar of AndyAinscow
AndyAinscowFlag for Switzerland

asked on

ADO recordsets created in memory

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?


Avatar of AlexFM
AlexFM

Looks like ADO+ task, but it exists only in .NET. Do you need only unmanaged solution?
Avatar of AndyAinscow

ASKER

Thanks Alex, unmanaged if possible please (The app won't be .NET based).

If it isn't possible then I can live without it but a .NET solution could be of interest for later.
ASKER CERTIFIED SOLUTION
Avatar of clockwatcher
clockwatcher

Link to home
membership
This content is only available to members.
To access this content, you must be a member of Experts Exchange.
Get Access
Thanks clockwatcher - I'll study that code later and get back.
clockwatcher - eyeballing the code and it looks a nice piece of work to base things on.  As no one else has responded it looks like there is no in-built functionality to achieve this.

Thankyou.