MySQL Forums
Forum List  »  General

Multi-Statement SQL
Posted by: David Roberts
Date: April 05, 2005 02:35PM

I am using Delphi 7 ADO components (TADOQuery) to integrate with MySQL 4.1.

Whenever I issue multiple SQL DML statements (like several INSERT statements) in a single query string it fails because there is more than one statement. I don't have this problem with SQL Server.

Is there something I can specify in the ODBC DSN or on the MySQL server itself to enable multiple statements? I have found reference to these articles, but I am unsure of how to use them:

http://dev.mysql.com/doc/mysql/en/c-api-multiple-queries.html
http://dev.mysql.com/doc/mysql/en/mysql-set-server-option.html

Thanks,

Dave

Options: ReplyQuote


Subject
Written By
Posted
Multi-Statement SQL
April 05, 2005 02:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.