Page 1 of 2
Problem with bigint(8) "Débordement BCD"
Posted: Thu 13 Mar 2008 17:39
by webpac
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.
Posted: Fri 14 Mar 2008 12:37
by Antaeus
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.
Posted: Mon 17 Mar 2008 10:17
by webpac
Hello,
do you know when the next build is released ?
How can I be informed when it's released ?
Thanks,
Posted: Mon 17 Mar 2008 11:42
by Antaeus
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.
Posted: Thu 10 Apr 2008 13:03
by webpac
Do you know when the new DbxMda with the correction is released ?
I'm still waiting for it, thanks.
Posted: Thu 10 Apr 2008 15:17
by Dimon
Please send your registration information to dmitryg*crlab*com. Also specify the Delphi version you are using.
Posted: Thu 10 Apr 2008 15:38
by webpac
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.
Posted: Fri 11 Apr 2008 12:31
by Dimon
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.
Posted: Fri 11 Apr 2008 12:36
by webpac
Please send it to pascal1.lib _at_ free _dot_ fr
I'll respond if it works or not. Thanks
Posted: Mon 14 Apr 2008 11:46
by webpac
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.
Posted: Mon 14 Apr 2008 12:02
by webpac
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.
Posted: Tue 15 Apr 2008 09:24
by Dimon
The next dbExpress build will be released in the course of the next week.
Posted: Tue 15 Apr 2008 09:41
by webpac
Thank you for the answer.
Posted: Wed 21 May 2008 15:59
by webpac
Any schedule for the next dbExpress build release ?
Posted: Mon 26 May 2008 13:38
by webpac
Up.