Does Provider = Microsoft.Jet.OLEDB.4.0 support multiple ADO recordsets?

Does Provider = Microsoft.Jet.OLEDB.4.0 support multiple ADO recordsets?

Post by debarts » Sun, 30 Nov 2003 03:45:14


Hi Everybody,

I'm using a disconnected ADO 2.0 Recordset (CursorLocation=adUseClient) with
the Microsoft.Jet.OLEDB.4.0 provider to query data out of a Microsoft Access
97 database for a desktop application. I'm unsuccessfully trying to execute
a query which returns multiple recordsets using a semi-colon as the
delimiter between sql statements

i.e. sql = "Select * FROM TableA;Select * FROM TableB"

Does anyone know for sure if multiple recordsets are supported with this
provider?

Thanks for any help!
Sam
 
 
 

Does Provider = Microsoft.Jet.OLEDB.4.0 support multiple ADO recordsets?

Post by Mike Colli » Sun, 30 Nov 2003 05:11:02

> i.e. sql = "Select * FROM TableA;Select * FROM TableB"

As far as I know you can't use the above syntax with JET (I haven't seen it
used in any other ADO provider either).

Perhaps an SQL "JOIN " or "UNION" statement will do what you want, a search
in google should give examples.

Mike Collier BSc (Hons)
ADO Browser for viewing ADO properties & events on your system.
http://www.yqcomputer.com/
https://www.regsoft.net/regsoft/vieworderpage.php3?productid=64520