Hi! Many people have complained over years that Borland's dbExpress driver does not work with MySQL and transactions, because it disconnects from mysqld after each SQL statement. The postings below suggests that this problem might now be fixed by Borland.
Best regards, Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a non-free hot backup tool for MySQL ........... From: Ramesh Theivendran ([EMAIL PROTECTED]) Subject: 20483: dbExpress MySQL 4.0.x Beta driver View this article only Newsgroups: borland.public.delphi.database.dbexpress Date: 2003-08-15 17:52:29 PST MySQL 4.0.x Beta available in Code central. Will be updated with the remaining bug fixes soon. T.Ramesh. From: Ramesh Theivendran\(Borland\) ([EMAIL PROTECTED]) Subject: Re: 20483: dbExpress MySQL 4.0.x Beta driver View this article only Newsgroups: borland.public.delphi.database.dbexpress Date: 2003-08-21 17:46:26 PST Nikola, I will have to investigate the issue with LAST_INSERT_ID() >>since dbExpress MySQL driver disconnects from >>server with every query :(. No, dbExpress driver don't disconnect after every query. My guess is, it could be either because of the issue with cloning connections in the components or with MIDAS ApplyUpdate()commiting a transaction. Anyway, once i investigate more i'll know. T.Ramesh. ........................... "Nikola Savic" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Ramesh Theivendran wrote: > > MySQL 4.0.x Beta available in Code central. Will be updated with the > > remaining bug fixes soon. > > Dear Mr. Ramesh, > does new dbExpress driver for MySQL 4.0.x support auto_increment > fields when used as primary keys ? We have a lot of problems working > with MySQL/dbExpress combination, since there is no way to automatically > get newly generated primary key. When MySQL function LAST_INSERT_ID() is > used, it returnes 0, since dbExpress MySQL driver disconnects from > server with every query :(. > We were ready to write our own dbExpress driver, but there was no > details online on how it should be done. > > I hope you can help us with this big problem, which is, I'm sure, > stoping a lot of developers to use Delphi with MySQL in right and most > productive way ! > > > LOGIK > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
