DELIMITER Problem of TMyDump Restore / TScript Execute
Posted: Mon 14 Feb 2011 03:38
Recently I use Your dbForge Studio to generate scripts for version different to be applied to all clients.
However, while the generated script work perfectly when running by dbForge / SQLYog, it cannot be run directly by TMyDump.Restore or TScript.Execute.
I found that the error is that the generated script keep the newly defined Delimiter immediate after some statements which MyDAC expect them to be separated by space / line feed.
For example, the dbForge Compare generate :
DELIMITER $$
DROP PROCEDURE GenPO$$
CREATE PROCEDURE GenPO(IN StoreIDs VARCHAR(100))
BEGIN
but MyDAC report Syntax error before 'CREATE PROCEDURE'.
When I add a space before $$ :
DROP PROCEDURE GenPO $$
It work fine.
So, I need to manually add space before the Delimiter.
I hope this issue can be fixed in either dbForge / MyDAC so that the operation is more smooth and efficient.
Thank you very much.
Delphi 2010
dbForge 4.50.321
MyDAC 6.00.0.4
MySQL 5.1.54
However, while the generated script work perfectly when running by dbForge / SQLYog, it cannot be run directly by TMyDump.Restore or TScript.Execute.
I found that the error is that the generated script keep the newly defined Delimiter immediate after some statements which MyDAC expect them to be separated by space / line feed.
For example, the dbForge Compare generate :
DELIMITER $$
DROP PROCEDURE GenPO$$
CREATE PROCEDURE GenPO(IN StoreIDs VARCHAR(100))
BEGIN
but MyDAC report Syntax error before 'CREATE PROCEDURE'.
When I add a space before $$ :
DROP PROCEDURE GenPO $$
It work fine.
So, I need to manually add space before the Delimiter.
I hope this issue can be fixed in either dbForge / MyDAC so that the operation is more smooth and efficient.
Thank you very much.
Delphi 2010
dbForge 4.50.321
MyDAC 6.00.0.4
MySQL 5.1.54