Devart Forums

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

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.