ExecuteDirect + DDL script

Moon Wolf · Post by **Moon Wolf** » Thu 04 Feb 2010 13:41

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…

Dimon · Post by **Dimon** » Fri 05 Feb 2010 07:41

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.

Moon Wolf · Post by **Moon Wolf** » Fri 05 Feb 2010 09:10

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.

Dimon · Post by **Dimon** » Fri 05 Feb 2010 10:26

If any other questions come up, please contact me.