--I have solved this problem by rolling back my version of Query Browser to 1.1.20; if you take any of the following code and paste it into that version of query browser it will execute fine, placing it in 1.2.3 beta will cause syntax errors.
Ok,
I have been screwing around with this for 3 hours now and can not figure this out. I am using MySQL 5.0, Query Browser 1.2.3 beta, and Administrator 1.1.
I used the MySQL migration tool to pull in an old Access Database and this worked beautifully and without error so I started up Query Browser and went to create a stored procedure and Query Browser gave me its default template:
Code:
DELIMITER $$
DROP PROCEDURE IF EXISTS `zips1`.`uspTest` $$
CREATE PROCEDURE `zips1`.`uspTest` ()
BEGIN
END $$
DELIMITER ;
I went about my business building the SP and went to execute it, and I got a 1064 error (Syntax error) so I went back and looked at my code and couldnt find anything that jumped out at me.
Eventually i had removed all of my code and tried to simply execute the above syntax (that was generated by Query Browser) and it fails as well with a 1064 error of:
Code:
You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near 'DELIMITER $$
DROP PROCEDURE IF EXISTS `zips1`.`uspTest` $$
CREATE PROCEDURE ' at line 1
If I do this:
Code:
CREATE PROCEDURE uspTEST()
SELECT * from [TABLE];
Query browser creates the stored procedure and it works fine but if I go and do something like this:
Code:
CREATE PROCEDURE uspTEST()
DECLARE myVariable int;
Query Browser barks about the DECLARE statement being incorrect! Can someone explain to me what exactly is going on?
--Stole this from a moderator
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.
Syntax Error -- BUG REPORT Solved
on their post!
