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 (rt**********@borland.com)
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\) (Ra****************@borland.com)
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 fromNo, dbExpress driver don't disconnect after every query. My guess is, it
server with every query :(.
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" <ni****@medianis.net> wrote in message
news:3F**************@medianis.net... 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/my***********...ie.nctu.edu.tw