BCD Overflow

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
Posts: 1
Joined: Sat 21 Mar 2015 19:15

BCD Overflow

Post by evandro.abreu » Mon 23 Mar 2015 13:51

Hello, is taking place the following error: BCD Overflow.
The error occurs when the following line:

vlTotal: = QATPR.fieldbyname.('vl_fixado').AsFloat;

EnableBCD is true.
Driver version 3.5.7
Delphi 7
PostgreSQL 9.1

How do I correct this problem?

P.S. Translation by Google Translator.

Devart Team
Posts: 1119
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: BCD Overflow

Post by azyk » Tue 24 Mar 2015 13:44

The 'BCD Overflow' error message can occur when the value retrieved from the database exceeds a limitation for the TBcd type in Delphi 7. For example, when the number of digits in such BCD value exceeds 32 (in PostgreSQL - numeric(33,1)). In such cases, the error is generated by Delphi - and we can't affect this behavior.

Please specify the data type you are using for the 'vl_fixado' field in PostgreSQL.

Post Reply