Problem retrieving fields with decimal.

[pepito_juanito]

Hello!

I´m starting to work with dbxmda. We create a test table on mysql with this query in mysql command line client :

create table test (one decimal(1), two decimal(2), three decimal(3), four decimal(4));
insert into test values (1,22,333,4444);

When I write a test aplication with a TCRSQLConnection, TSQLDataSet (commandtext: 'select * from test'), TDataSetProvider, TClientDataSet and TDataSource with a TDBGrid connected it looks that it retrieves one number less than field size. Something like this (in the dbgrid component of course):

|one | two | three | four|
===================
| 0 | 2 | 33 | 444|

I´ve been developing with dbexpress for a while. With other drivers we haven´t this problem. Do I miss something?

Thanks in advance. Sorry about my english

Delphi pro 6.02
dbxmda 2.60.7
nt server2003
mysql 4.0.14 (linux and winnt).
Tested with innodb and myisam. Tested with sqlclientdataset and sqldataset. Tested with direct connect and using libmysql.dll

[Ikar]

Thank you for information.
We reproduced your problem and fixed it. This fix will be included in the next DbxMda build. It will be available in about three weeks. Please look forward for announcments at the forum

[pepito_juanito]

Thanks for your reply and fast response. Thats the kind of things that turned us to buy your drivers.

We are planning to port an application from dbxoodbc to your driver. Is there any posibility to get this patch sonner than three weeks? Something like a beta release or something like that. We were expecting to start working on that this week.

I understand the schedule problems (I have many of these). Thanks again.

[Ikar]

The answer has been sent to you by email

[Guest]

I am having exactly the same problem. I have installed the latest drivers of dbxMda (2.80.8, then 3.00), I am using mySQL 5.0.16 and Delphi 6 Ent, update pack 2. But the problem is still there. In some tables the field type is Decimal(2,0), the value in it is for example '10', but in dbGrid this value is shown as '1'. Is this Delphi or your bug?

Thanks for the answer!

[Ikar]

This is Delphi NormalizeBCD bug. We will try to avoid it in nearest build.

[waldude]

I too am having the issue. Any idea when a new build will be available?

[Ikar]

New build was released and you can download it (3.00.1) now from Core Lab server.

[dpaq]

I am having this same problem with version 3.0.0.1, Delphi 2006, and MySQL 5.0

-David

[Ikar]

We couldn't reproduce the problem.
Please send us (dbxsda*crlab*com) a complete small sample to demonstrate it, including script to create and fill table.

[Guest]

Delphi 6.0, mySQL 5.0 - no problems with decimal fields anymore! But I had dbexpmda.dll file also where my .exe was (not so smart), so don't forget to copy new version of dll in .exe folder, if you are doing things like me...