Android Question RDC MySQL Handling multiple resultsets from Stored Proc call

[timbald]

Hello all,

I'm using RDC to access a MySQL database. The command config.properties in RDC is a CALL sp_SomeStoredProc() - which returns two results sets (two select statements one after the other).

How does RDC in B4A handle processing two (or more) results sets from one RDC call please?

Thanks!

 

[Erel]

It will not work. You can switch to jRDC and then implement this query on the server side.

 

[timbald]

Thought as much. I'll separate any multi resultsets from each Stored Proc for ease.
Thanks as ever for the swift response.