[Gambas-user] Error on gb.db.mysql: Commands out of sync; you can't run this command now

[David Villalobos Cambronero]

Sure, here it is:

mysql: 0x7b3680: CALL `sp_Procedimientos`
mysql: 0x7b3680: CALL `sp_Tablas`


And it fails on the second CALL, showing the messasage I sent you.

Atacched the code form my form.


Reagards


--
David



----- Original Message ----
From: Benoit Minisini <gambas at ...1...>
To: mailing list for gambas users <gambas-user at lists.sourceforge.net>
Sent: Wednesday, January 14, 2009 5:39:12 PM
Subject: Re: [Gambas-user] Error on gb.db.mysql: Commands out of sync; you can't run this command now

On lundi 12 janvier 2009, David Villalobos Cambronero wrote:
> Not sure... but what I know for sure is that is not in my Gambas part.
> Attached is an example using only gb.db
>
>  I try to take a look in the C part, but I couldn't find anything.
>
> Attached is the entire script for my database, and an example.
>
> I you connect directly to mysql and execute the last tow statements they
> work, so I think it is a bug in the C part.
>
>
> MySQL says:
>
>
> If you get Commands out of sync; you can't run this command now in your
> client code, you are calling client functions in the wrong order. This can
> happen, for example, if you are using mysql_use_result() and try to execute
> a new query before you have called mysql_free_result(). It can also happen
> if you try to execute two queries that return data without calling
> mysql_use_result() or mysql_store_result() in between. Best Regards
>
>
> --
> David
>

Can you make the dump of all mysql requests sent by using DB.Debug = TRUE ?

-- 
Benoit Minisini

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Gambas-user mailing list
Gambas-user at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user



      
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FRMPermisos.form
Type: application/octet-stream
Size: 1511 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20090115/e9cf52d7/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: FRMPermisos.class
Type: application/x-java-vm
Size: 5912 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20090115/e9cf52d7/attachment.bin>