Xojo Conferences

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.
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

The biggest plugin in space...

MBS FileMaker tutorial videos