🚀 go-pugleaf

ming wrote:
> Hi, I was hit this problem when I perform an SQL sum statement like
> written below
>
> select iva2_reckey, sum(iva2_cost) from test
> group by iva2_reckey
>
>
>
> , the expected sum result should be 0 for each grouping yet I find
> there is one wired sum result displayed as 4.44089209850063E-16 for
> grouping valued 3.
>
> To test the proplem, Create a paradox table name test.db with
> structure and data like the following:
> IVA2_RECKEY INTEGER,
> IVA2_SEQNO INTEGER,
> IVA2_COST NUMERIC,
>
> PRIMARY KEY(IVA2_RECKEY, IVA2_SEQNO)
>
> IVA2_RECKEY,    IVA2_SEQNO,    IVA2_COST,
> 1                            0                            43.68
> 1                            1                            -10.00
> 1                            2                            -20.00
> 1                            3                            -13.68
> 2                            0                            11.46
> 2                            1                            -9.50
> 2                            2                            -1.96
> 3                            0                            11.46
> 3                            1                            -10.40
> 3                            2                            -1.06
> 4                            0                            -11.46
> 4                            1                            1.06
> 4                            2                            10.40
>
>
> just uses SQL Explorer to perform the mentioned SQL statement. Can
> somebody help me in
> this area? Thanks in advance for your help!

First, here is the newsgroup for Interbase, not bde
Second for your problem - you have data that actualy is
3                            0
11.4600000000000004
visually it is displayed rounded.
try to select it as string ie Cast(IVA2_COST as varchar(100))
Reenter data manualy and you will notice the difference.

If this are money you must always ensure in your program that only two
digits after decimal point are entered in the database.


--
Bojidar Alexanrov
Kodar Ltd.
http://www.Kodar.net