CODEWITHSUNDEEP
mysqlms-accessvbaresultsetadodb
David
David

Reputation: 2241

Multiple result sets from MySQL stored-procedure in MS-Access front-end using vba?

I'm familiar with using the ADODB Connection and ADODB Recordset in vba to iterate through records of a single result set from a stored-procedure from MySQL. But I now have a stored-procedure that returns multiple result sets. How do I access all result sets? Is it even possible?

Upvotes: 1

Views: 1032

Answers (1)

HansUp
HansUp

Reputation: 97101

Use the ADO NextRecordset Method

See the detailed example linked on that page.

Upvotes: 2

Related Questions