Xojo Developer Conference
25/27th April 2018 in Denver.
MBS Xojo Conference
6/7th September 2018 in Munich, Germany.

Platforms to show: All Mac Windows Linux Cross-Platform

FAQ.Does SQL Plugin handle stored procedures with multiple result sets?
Answer: Yes, the plugin can work with multiple recordsets.
Notes:
You need to use SQLCommandMBS class. When you get back results, you use FetchNext to walk over all records in the first result set. Than you simply start again with FetchNext to get the second record set.
Even the RecordSet functions should work, just use them twice to get all records from both record sets.

Feedback, Comments & Corrections




Links
MBS FileMaker Plugins