MyCommand not longer support multi SQL statement?

[Jonathan Liaw]

Hi,

It seem the multi SQL statement capability has been removed from MyCommand in version 3.50.0.16. Is this intended for the new version? I use version 3.30.2.15 and MyCommand happily execute the following test statements

DROP TEMPORARY TABLE IF EXISTS TempItem;
DROP TEMPORARY TABLE IF EXISTS TempItem;

but now in version 3.50, I get the following error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
DROP TEMPORARY TABLE IF EXISTS TempItem' at Line 1.

Please help

Jonathan Liaw

[Ikar]

It's strange that you could execute these queries using TMyCommand in the old version. MySQL Server doesn't support execution of several commands for one time and you have to use TMyScript.