I have a DBISAM table with the fields

verbruik : integer
prijs :  BCD (2)
totaal : BCD (2)

When I go through the table calculating as follows

with grid1.dataset do
    begin
    first;
    while not eof do
          begin
          if state=dsbrowse then update;
          columns['verbruik'].asinteger:=columns['begin'].asinteger-columns['eind'].asinteger;
          columns['bedrag'].asfloat:=columns['verbruik'].asinteger*columns['prijs'].asfloat;
          next;
          end;
    end;

I see a weird result (see screenshot)

18 * 1.70 = 30,6   result is EWB grid = 30,59999999998

Paul.

This is not EWB this the Browser and Javascript doing this.  Google javascript math accuracy.

On the Field Definition set the decimals to 2 it  will round.

Walter

Another link...

http://adripofjavascript.com/blog/drips/avoiding-problems-with-decimal-math-in-javascript.html

PROBLEM SOLVED !!  Thanks!


Walter Matte wrote:


This is not EWB this the Browser and Javascript doing this.  Google javascript math accuracy.

On the Field Definition set the decimals to 2 it  will round.

Walter