LAST_INSERT_ID() -- is is stable???
Posted: Thu 28 Jul 2005 17:37
Delphi 8sp3 user w/MySQL v4.0.x (plans to migrate to v4.1.x)
I purchased CoreLab dbExpress partially for 4.1 support, but mainly to try to get LAST_INSERT_ID() to work. Borland's driver connects/disconnects from the database when it should not, breaking LAST_INSERT_ID(); yes, I tried tweaking all of the "connections" options.
CoreLab dbExpress fixed this as soon as I installed it, no re-coding necessary.
1) Thanks!
2) Were you guys aware of this / is it a "stable" feature that I can count on going forward? My kludge work-around for the Borland product is not pretty or scalable, it would be a shame to have to actually use it.
I purchased CoreLab dbExpress partially for 4.1 support, but mainly to try to get LAST_INSERT_ID() to work. Borland's driver connects/disconnects from the database when it should not, breaking LAST_INSERT_ID(); yes, I tried tweaking all of the "connections" options.
CoreLab dbExpress fixed this as soon as I installed it, no re-coding necessary.
1) Thanks!
2) Were you guys aware of this / is it a "stable" feature that I can count on going forward? My kludge work-around for the Borland product is not pretty or scalable, it would be a shame to have to actually use it.