OSX 10.13.2
Xojo 2017r3
MySQL 5.0.87
I am trying to call a MySQL stored procedure as such:
sub function(arg1 as string)
dim stmt as string =_
"CALL myProcedure('" + arg1 + "')"
dim rs as RecordSet = mSqlServer.SQLSelect(stmt)
if rs <> Nil then
<DO STUFF>
end if
end sub
Which works fine, I get the record set I expect back. But the next time I try to call the above method I get a MySQL error:
Now, I know that this error relates to a problem with the order in which mysql_use_result() , mysql_free_result(), and mysql_store_result() are called. But, I presume that Xojo should be calling those within either the Recordset or MySQLCommunityServer objects. So, is this a problem with Xojo? Or any ideas about how to get around this?
UPDATE:
I can run this procedure (myProcedure) multiple times in a row using a different client than Xojo to access the MySQL Server
Thank you