Devart Forums

Hello,
I have a DDL script which I have to execute to create my database, but when I'm trying to do this I have an exception:
"You have an error in your SQL syntax....."
I've noticed that when you are trying to execute two (or more) commands in one ExecuteDirect (for example, “drop database x; create database x”) it doesn’t work.
How can I execute DDL using dbExpress?
Thanks…

I can not reproduce the problem.
Please send me a complete small sample to dmitryg*devart*com to demonstrate it.

Also supply me the following information:
- the exact version of DbxMda;
- the exact version of your IDE;
- the exact version of MySQL server.

The problem solved... I used Embarcadero's dbExpress drivers and not a dbxMDA. Now it works fine.
Sorry for my mistake and thanks for your reply.

If any other questions come up, please contact me.