JOIN Recordset with Table

[rvBasic]

Is it possible to join an in-memory recordset (ADODB) with an access table?

_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]

 

[RoyVidar]

As far as I know, no.

I think the join will need to be performed prior to opening it, else you'd need some looping.

Roy-Vidar

 

[rvBasic]

After some further googling, I came to the conclusion that it is not even possible to join two recordsets by natural sql commands.

Unless I overlooked something

_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]

 

[RoyVidar]

I think you're quite correct - to "join" recordsets, you'd need some looping (inner/outer-thingies).

Why not try to join prior to opening the recordset(s)? That's usually much more efficient than recordset approaches.

Roy-Vidar

 

[rvBasic]

RoyVidar: the recordset is obtained as a property of a class object. Therefore, in priciple, its underlying query is not exposed to the program.

As I also wrote the class code, I have obviously access to that query, so I could write a new join. But then I have to maintain at least partially twice the same join.

Hence the question.

Thanks for replying.

_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]