ExecuteDirect + DDL script

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
Moon Wolf
Posts: 4
Joined: Thu 04 Feb 2010 13:24

ExecuteDirect + DDL script

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

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
Posts: 4
Joined: Thu 04 Feb 2010 13:24

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
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 05 Feb 2010 10:26

If any other questions come up, please contact me.

Post Reply