BCD Overflow

BCD Overflow

Postby 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.
Posts: 1
Joined: Sat 21 Mar 2015 19:15

Re: BCD Overflow

Postby 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.
Devart Team
Posts: 962
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Return to dbExpress driver for PostgreSQL