Problem with bigint(8) "Débordement BCD"

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Problem with bigint(8) "Débordement BCD"

Post by webpac » Thu 13 Mar 2008 17:39

Hello,

when I try to open a query with a field that is defined as bigint( 8 ), I got the error message "Débordement BCD".

The field has got for example the value 795114345.

I'm working with Delphi7, I tried with an old dll version and the newest 4.20 version and both make the same error.

I got the same problem on Oracle and the solution was :

Code: Select all

const
  coEnableBCD = TSQLConnectionOption( 102 );
begin
  FSQLConnection.Open;
  FSQLConnection.SQLConnection.SetOption( coEnableBCD, Integer( False ) );
end;
I tried the same code with MySQL but it doesn't solve the problem.

What's the problem and how can I solve it ?
Thanks.

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 14 Mar 2008 12:37

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next build of DbxMda. As a temporary solution you we can suggest altering BIGINT(x) type with BIGINT. Another solution is to create fields at design time and set the Precision property of fields corresponding the BIGINT(x) data type to 20.

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Mon 17 Mar 2008 10:17

Hello,

do you know when the next build is released ?
How can I be informed when it's released ?
Thanks,

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Mon 17 Mar 2008 11:42

We are planning the new build of DbxMda in two or three weeks.
We will post an announcement at this forum after the new build is available.

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Thu 10 Apr 2008 13:03

Do you know when the new DbxMda with the correction is released ?
I'm still waiting for it, thanks.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Thu 10 Apr 2008 15:17

Please send your registration information to dmitryg*crlab*com. Also specify the Delphi version you are using.

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Thu 10 Apr 2008 15:38

I have got an old Dbxmda.dll version, I have to buy a new one when the new version wich corrects this bug is released.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 11 Apr 2008 12:31

We can send you for test the Trial Edition of the last DbxMda including the fix to this problem. Please, let us know your e-mail.

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Fri 11 Apr 2008 12:36

Please send it to pascal1.lib _at_ free _dot_ fr
I'll respond if it works or not. Thanks

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Mon 14 Apr 2008 11:46

Hello,
I can't try the trial version because I got the 30 free days expired.
So I don't know if it works or not.

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Mon 14 Apr 2008 12:02

Sorry,
I found another computer that hasn't got the 30 days trial expired.
The new dll fixes the bugs.
Do you know when the dll will be released ?
Thanks.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 15 Apr 2008 09:24

The next dbExpress build will be released in the course of the next week.

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Tue 15 Apr 2008 09:41

Thank you for the answer.

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Wed 21 May 2008 15:59

Any schedule for the next dbExpress build release ?

webpac
Posts: 32
Joined: Wed 04 Apr 2007 16:13

Post by webpac » Mon 26 May 2008 13:38

Up.

Post Reply