Wrong amount by using then SQL SUM-Statement

Alfred Günthner

Delphi Developer

Wed, 04 Dec 2002 03:00:00 GMT

Wrong amount by using then SQL SUM-Statement

It's strange!

I use Delphi 5.0 Prof. with BDE 5.1.1.

If I try to add 5 amounts of a numeric column (paradox-table) I miss 0,01.
It must be a error by rounding!
How can it happen?

The SQL-statement is

Select sum(<field>)
from <table>
group by <field>

Thanks for help

Team

Delphi Developer

Wed, 04 Dec 2002 03:00:00 GMT

Re:Wrong amount by using then SQL SUM-Statement

The Numeric data type in Paradox tables is actually a floating point field.
Since binary floating point notation cannot represent most decimal fractions
exactly rounding errors can occur.

--
Bill Todd (TeamB)
(Questions received via email cannot be answered.)

Other Threads

1. SQL Order by Sum(Amount)

2. Using Sum in Insert Statement.

3. Problems with SUM in SQL statement

4. Problem with SQL statement sum in 32 bits ?

5. Problems with SUM in SQL statement

6. SELECT statement using LIKE the wrong way round

7. What is wrong with this SQL statement???

8. What's wrong with my SQL Statement?

9. wrong sql statement or sth else...

10. what is wrong? (SQL Statement)