 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Lincoln
Guest
|
 Posted: Mon May 21, 2007 2:09 pm Post subject: Delphi 2007 - Bugs in dbExress for MySQL |
 |
|
I just got my Delphi 2007 box and started to test immediately. First
things I discovered are several bugs in dbExpress for MySQL.
1. Stored Procedure Scope
Even if a database is specified in TSQLConnection.Params, the
TSQLStoredProcedure component offers ALL stored procedures of ALL
databases on the MySQL Server if you connect as root. No heavy bug but
not nice.
2. DateTime Parameters in Stored Procedures
If a stored procedure requires a parameter with MySQL datatype
"datetime", it can't be called. Error: "Parameter xy has no value".
MyQLStoredProc.ParamByName('birht').AsDatetime:=Now; // doesn't work
MyQLStoredProc.ParamByName('birht').AsDatetime:=Today; // doesn't work
MyQLStoredProc.ParamByName('birht').Value:=Today; // doesn't work
Everything is tested with stable MySQL 5.0.41.
Everything is also tested with CoreLab's MySQL driver
v3.20 for dbExpress - and both works fine. As it does in BDS2006.
My hope was to use Delphi 2007's included dbExpress driver instead of
the well-working but expensive CoreLab drivers. Are there any bugfixes
availibel for Delphi 2007's dbExpress drivers?
Lincoln |
|
| Back to top |
|
 |
Dmitry Arefiev
Guest
|
| Posted: Mon May 21, 2007 5:32 pm Post subject: Re: Delphi 2007 - Bugs in dbExress for MySQL |
|
|
| Quote: | My hope was to use Delphi 2007's included dbExpress driver instead of
the well-working but expensive CoreLab drivers.
|
But you can try 3d party products, like the AnyDAC. It is freeware
and much more feature reach, than dbExpress components.
Regards,
Dmitry
--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase
ASA, DbExpress, ODBC freeware data access engine
ThinDAC - multitier data access engine |
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Mon May 21, 2007 7:56 pm Post subject: Re: Delphi 2007 - Bugs in dbExress for MySQL |
|
|
Lincoln wrote:
| Quote: | I just got my Delphi 2007 box and started to test immediately. First
things I discovered are several bugs in dbExpress for MySQL.
1. Stored Procedure Scope
Even if a database is specified in TSQLConnection.Params, the
TSQLStoredProcedure component offers ALL stored procedures of ALL
databases on the MySQL Server if you connect as root. No heavy bug
but not nice.
2. DateTime Parameters in Stored Procedures
If a stored procedure requires a parameter with MySQL datatype
"datetime", it can't be called. Error: "Parameter xy has no value".
|
Please make sure these problems are entered in QC with a reproducible
test case so they can be fixed in the next update.
--
Bill Todd (TeamB) |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
