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

webpac · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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 · 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 · Post by **Dimon** » Tue 15 Apr 2008 09:24

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

webpac · Post by **webpac** » Tue 15 Apr 2008 09:41

Thank you for the answer.

webpac · Post by **webpac** » Wed 21 May 2008 15:59

Any schedule for the next dbExpress build release ?

webpac · Post by **webpac** » Mon 26 May 2008 13:38