W O wrote:
Never use double precision for money neither for count something, use it
for measures.
Actually, you can use it to _count_ as long as all individual items are
integers. Double precision is built that way to keep integer arithmetics
clean as long as all operands are integers and
Never use double precision for money neither for count something, use it
for measures.
Greetings.
Walter.
On Sat, Jun 2, 2012 at 2:06 PM, Mark Rotteveel m...@lawinegevaar.nl wrote:
**
On 2-6-2012 19:47, softdestek wrote:
ACCOUNTS.DEBT is double
ACCOUNTS.RECEIVABLES is double
MY
ACCOUNTS.DEBT is double
ACCOUNTS.RECEIVABLES is double
MY QUERY
SELECT
SUM(ACCOUNTS.DEBT),
SUM(ACCOUNTS.RECEIVABLES),
sum(ACCOUNTS.DEBT)-SUM(ACCOUNTS.RECEIVABLES)
FROM ACCOUNTS
WHERE ACCOUNTS.CODE='100'
1) SQL RESULT
SUM(ACCOUNTS.DEBT)