RE: mysql query browser

I just downloaded and installed QB 1.1.2

I cannot run the scripts that contain a single SELECT or even SET statement -- I still get error 2014, "Commands out of sync; you can't run this command now".
 
-----Original Message-----
From: Michael G. Zinner [mailto:[email protected]]
Sent: Thursday, November 04, 2004 5:54 AM
To: Marie Rose Van Boxstael
Cc: [email protected]
Subject: Re: mysql query browser


Hi,

This is now fixed and will be in the next release of QB (out tomorrow).

The problem was caused by using commands that return a resultset, like a 
SELECT or CALL, in the script. This resultset was not fetched and 
therefore the commands ran out of sync.

The fix we did is to fetch but ignore resultsets if they occure during 
the script.


Please notice that a script should only contain DDL statements like

DELIMITER \\

DROP PROCEDURE IF EXISTS `test`.`foo`\\
CREATE PROCEDURE `test`.`foo` ()
BEGIN
   // Your code
END\\

DELIMITER ;

or CREATE TABLE statments.


Please install the new QB 1.1.1 release tomorrow and verify the fix if 
possible.

Thanks a lot,
Mike

Marie Rose Van Boxstael wrote:
> Hi,
> 
> I am trying to run a script file within the mysql query browser. I open it in a script tab, and then try to execute it with the execute buttom on the left of the screen. At that moment he loses the contents of schemata and I receive an error screen that he can't access the catalog and that the statements cannot be run. It's error 2014 he gives me.
> I've looked in all the documentation of MYSQL, but cannot find the answer.
> When I run the script file from the mysql cliënt dos window, everything goes fine.
> What's wrong here? Can anyone help me? It would be practical to run the script in the query browser.
> 
> thanks ,
> 
> marie rose van boxstael
> 

-- 
Michael Zinner, GUI Developer
MySQL AB, www.mysql.com
Office: +43 676 753 26 30

Are you MySQL certified?  www.mysql.com/certification

-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL GUI Tools Mailing List
For list archives: http://lists.mysql.com/gui-tools
To unsubscribe:    http://lists.mysql.com/[email protected]