Working with adodb recordsets (virtual and table based)

I have defined a virtual ADODB recordset that captures what I need in the sheet.
"SELECT Job, DateCurr, DateERP FROM RST1 R"

I need to query the associated dates in our ERP system

The table in the ERP, connected thourgh SQL
"SELECT Job, DateERP FROM dbo.WipMaster W"

Of course I could do a 3rd query combining the first two recordsets. My question is a syntax one; can I avoid doing it and create directly something that will be;
R.Job, R.DateCurr. W.DateERP ?

I tried ;

Please Login or Register  to view this content.

I guess that I can't do that as it sends the line to the SQL server (?) I get an error 13 type mismatch on rstADO rstADO is my 'virtual' recordset that I populated and checked the content with debug.

I get an SQL error; Invalid Object Name 'RST1'

(In my 2nd post, RST1 has become rstADO)

I suspect that you'd be better off generating an in clause on job id for SQL server from your recordset and then comparing against that

I'll go out on a limb and say it won't as it's unlikely that MSSQL has access to the C: drive of a random user, or indeed access to anywhere much!

I have an hunch that I am not doing it right.

I have two recordsets that I want to combine on job=job, so it would be a query maybe?

I see.

Sorry if it sounds a bit compliated, byt possibly the solution back to my original idea in this THREAD. Using an array instead of the first recordset.

Thanks to the gentleman there, I was able to get a recorset based on an array, but I couldn't get to the point of simply having Job [from the array], DateCurr [from the array], DateERP [from the recorset]. I guess that I would need a 3-columns array and the 3rd coplumn column would be updated from the recordset.