BCD overflow

BCD overflow

Postby 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.
Claudio
 
Posts: 25
Joined: Tue 17 Mar 2009 12:47

Postby 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

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for PostgreSQL