Getting Error When Creating An Sp

[peterlaursen]

I believe that the HTML encoding removes some spaces-

You have (when I copy)

Quote:

DELIMITER $$

CREATE PROCEDURE testing()

BEGIN

select * from test1;

END$$

DELIMITER;

Please try to remove the leading spaces. I can reproduce it with the leading spaces. But not if I remove them. If this is the problem it is a bug with the SQLyog 'tokenizer'.

Alos please tell what program version you are using. 9.33 or 9.4 beta. This is important for us to know.

[peterlaursen]

OK .. verifed.

If DELIMITER -keyword does not start on first postion in the editor it causes a tokenizer failure (the 'tokenizer' is the code that identifes where a statement starts and stops basically).

I have added this to our issue-tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1739

[Author]

Posts