DELIMITER Problem of TMyDump Restore / TScript Execute

[Justmade]

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

[AndreyZ]

Hello,

Thank you for the information. We have fixed this problem. This fix will be included in the next MyDAC build.