Xojo Conferences
XDCMay2019MiamiUSA

Re: [MBS] MBS SQL Plugin Question (MBS Xojo Plugin Mailinglist archive)

Back to the thread list
Previous thread: [MBS] Someone going to REAL Studio Summit in Atlanta from Europe?
Next thread: [MBS] ThreadMBS


Re: [MBS] MBS SQL Plugin Question   -   Christian Schmitz
  [MBS] MBS SQL Plugin Question   -   Todd Fantz

Re: [MBS] MBS SQL Plugin Question
Date: 03.01.11 22:56 (Mon, 3 Jan 2011 22:56:30 +0100)
From: Christian Schmitz

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

[MBS] MBS SQL Plugin Question
Date: 03.01.11 22:54 (Mon, 3 Jan 2011 16:54:03 -0500)
From: 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.

Most of the Googling on that have has turned up results referring to MySQL version numbers or stored procedures. I am not using stored procedures and have the same results against a variety of MySQL versions... and things have always worked fine with the RB Plugin.

I have tried to replicate it with a smaller project but have not been able to yet. Any thoughts or experiences?

OSX 10.6.5 RB2005r5.1

Regards,

Todd Fantz

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