Returning Multiple Resultsets with Jet

  • Thread starter Thread starter Chris Lane
  • Start date Start date
C

Chris Lane

Hi,

I was wondering if you can return multiple Resultsets with
Jet 4.0. I keep getting an error on the ; .

Dim sSql As String = "SELECT Full_Name FROM States WHERE
Country_ID = " & CountryID & " ORDER BY Full_Name;" _
& "SELECT * FROM Countries ORDER BY Name;"

Does this work with Jet 4.0?

Thanks
 
Nope. JET is incapable of returning multiple resultsets.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
OK, Thank You Bill.
-----Original Message-----
Nope. JET is incapable of returning multiple resultsets.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________




.
Click to expand...
 
Back
Top