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?
I can run this procedure (myProcedure) multiple times in a row using a different client than Xojo to access the MySQL Server