BCD overflow

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for PostgreSQL in Delphi and C++Builder
Post Reply
Claudio
Posts: 25
Joined: Tue 17 Mar 2009 12:47

BCD overflow

Post by Claudio » Tue 17 Mar 2009 13:02

Hello,

When I execute a call of the field I receive the message:

BCD Overflow;

Details:
EnableBCD = True;

CREATE funcao () RETURNS numeric as $BODY$
begin
return cast (1 as numeric (15,2));
end; $BODY$ LANGUAGE 'plpgsql';

SQLQuery. SQL.Text: = ' select funcao () ';
SQLQuery. Open;
if SQLQuery. Fields [0] .AsFloat> 0 then .... <--- ERROR HERE

Thank you.

PS: I need work with EnableBCD.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 19 Mar 2009 09:32

We have reproduced this problem, and we are working on it. You will be notified when we fix the problem.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 16 Apr 2009 09:01

We have added the fix. So that NUMERIC fields with no precision specified will be always mapped on TFloatField.

dbExpress requires to BCD fields have a precision set. We cannot create BCD field if the precision is unknown.

The fix will be included in the next build of the driver.

Post Reply