I posted this message in the Delphi/Kylix newsgroups but didn't get a definitive answer so I'll try it here. I'm using Delphi 6 Enterprise and DBExpress to access a MySQL database running on a Suse box. I'm using a MySQL-Max distribution and InnoDB table types that support transactions. Unfortunately I can't get transactions to work properly (e.g. ROLLBACK has no effect if a transaction is aborted). The TSQLConnection TransactionsSupported property returns false, which is to be expected for MySQL, but I have tried running transactions by sending the transaction control statements to the server directly (SET AUTOCOMMIT=0, BEGIN, COMMIT, ROLLBACK) using TSQLConnection.Execute but this does not work (although the Delphi Help seems to indicate that it should). Has anyone succeeded in getting MySQL transaction support to work in either Delphi or Kylix using DbExpress ? Kevin McBrearty ATG Automation Technologies Group Ltd. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
