[BUG] wrong position of ';' in SQL of exported tables

First, let me thank you for the work on this program (and mysqlfront 2.5 which I've been using for a long time)!

Now, the bug.
When exporting some tables to SQL you get something like:

/*!40000 ALTER TABLE myTable DISABLE KEYS;*/

and it should be

/*!40000 ALTER TABLE myTable DISABLE KEYS */;

I only noticed it when MySQL complained while trying to import the data via the command line executable.
mysqldump uses the second format also (at least on my 4.1.x version).

Fixed!

See http://svn.sourceforge.net/viewvc/heidisql/exportsql.pas?view=log

Excelent!
Thank you!

It's not we who are wrong, it's MySQL.

Yeah, rosenfield just made the whole thing more server-independent by adding a new option "Standard ANSI SQL" to the dropdown "Target compatibility".

If you select this new entry, the semicolons will be placed within the comment - which is the more correct syntax, but not (yet) supported by the mysql-servers.

If you choose one of the MySQL-options here, the semicolons will be placed outside the comment - which is needed if you want to re-import the file into another mysql-server.

Any idea when the new version will be available for download with this fix? :)

haha, I waited for this question :)

Sorry, no release plan yet. But you are free to download the sources and compile it for your needs.