MySQL Error for DELIMITER

[Zaheer]

Hi,.... I am getting an error for MySQL 5.0 Script file Procedures
I have gone through one of the Thread in this forum which to some extent was similar problem the link is http://www.advancedinstaller.com/forums ... ter#p50676 and have split my script file into 2 files and made all the things which was shown in the thread
but was not successfull so i am attaching my SQL Script file for procedure which is seperated from tables and the data please look over and provide the Solution ,The Error i am getting is


{SQL_ERROR}:{SQL_STATE:42000}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;;
/*!50003 DROP PROCEDURE IF EXISTS `deleteRowsBeforeUpDate`*/;;
/' at line 1

[Zaheer]

Hi Please Reply for this i am waiting

[Dan]

Hello Zaheer and welcome to Advanced Installer forums,

First of all, there have been some improvements about this starting with the 10.9 version of Advanced Installer.
Please upgrade, if possible to the latest version of Advanced Installer (currently 10.9.1).

As you can see in the Release 10.9 Notes, it has been added the:
"Enabled support for MySQL batched statements (set MULTI_STATEMENTS option by default)"

MySQL DELIMITER command is not supported by MySQL ODBC driver that Advanced Installer uses. In order to be able to use ; as statement delimiter within your stored procedures, you must NOT use it as SQL batch "Statement separator" in SQL script settings. Leave this field blank. Default value is ;

Starting with version 10.9 of Advanced Installer, we support batched statements for MySQL without the need to specify a batch statement separator (;)
After properly configuring the script settings, eliminate all DELIMITER commands from you script.

If you are unable to upgrade to AdvInst 10.9 or newer, you can use a custom connection string for MySQL and append MULTI_STATEMENTS=1;

If you have other questions, please let us know.

Best regards,
Dan