Devart Forums

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.

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

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.