Xojo Conferences
MBSSep2018MunichDE
XDCMay2019MiamiUSA

Re: [MBS] Re: Mbsplugins monkeybreadsoftware.info Digest, Vol 318, Issue 2 (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] 10.5 Plugins for RB 5.5.5?
Next thread: [MBS] Someone going to REAL Studio Summit in Atlanta from Europe?


Re: [MBS] Re: Mbsplugins monkeybreadsoftware.info Digest, Vol 318, Issue 2   -   Christian Schmitz
  [MBS] Re: Mbsplugins monkeybreadsoftware.info Digest, Vol 318, Issue 2   -   Todd Fantz

Re: [MBS] Re: Mbsplugins monkeybreadsoftware.info Digest, Vol 318, Issue 2
Date: 04.01.11 18:10 (Tue, 4 Jan 2011 18:10:22 +0100)
From: Christian Schmitz

Am 04.01.2011 um 18:00 schrieb Todd Fantz:

> First off, as for Atlanta, I'll be happy to take some time to drive you (and others) around or point you to some things worth seeing. Just let me know when you get in and what your schedule is. I live probably 15min from the airport.

That's good to know.

> As for the MySQL thing, all my recordsets are local in scope, and as mentioned I don't have a problem with the RB Plugin... I can add the code to force freeing the results after I am done, but I am at a bit of a loss on how to call mysql_free_result from within the SQL Plugin.

Well, you set the recordset property to nil?

Greetings
Christian

[MBS] Re: Mbsplugins monkeybreadsoftware.info Digest, Vol 318, Issue 2
Date: 04.01.11 18:00 (Tue, 4 Jan 2011 12:00:43 -0500)
From: Todd Fantz
First off, as for Atlanta, I'll be happy to take some time to drive you (and others) around or point you to some things worth seeing. Just let me know when you get in and what your schedule is. I live probably 15min from the airport.

As for the MySQL thing, all my recordsets are local in scope, and as mentioned I don't have a problem with the RB Plugin... I can add the code to force freeing the results after I am done, but I am at a bit of a loss on how to call mysql_free_result from within the SQL Plugin.

tf

On Jan 4, 2011, at 6:00 AM, <email address removed> wrote:

> Am 03.01.2011 um 22:54 schrieb Todd Fantz:
>
>> I am trying to swap in the MBS SQL Plugin in one of my projects that is currently using the RB MySQL DB plugin.
>>
>> The connection happens fine and the first query (maybe a couple) happens fine, but I start to get "Commands out of sync; you can't run this command now." errors from that point on.
>
> The MySQL FAQ talks about a missing mysql_free_result. Maybe your result set is not yet destroyed in REAL Studio?
>
> http://dev.mysql.com/doc/refman/5.0/en/commands-out-of-sync.html
>
> Greetings
> Christian

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
<email address removed>
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info