January 27, 2015, 01:03 PM
John_EdwardsWhy I Hate Computers
Just changed this --
TABLE FILE CLAIMS_DATA
BY PAY_NAME_UPCASE
WHERE BATCH_DT EQ '&RUNDATE_HYYMDS'
WHERE TOTAL DOLLARS_PAID GT 0
ON TABLE HOLD
END
. . . to this --
TABLE FILE CLAIMS_DATA
BY PAY_NAME_UPCASE
WHERE BATCH_DT EQ '&RUNDATE_HYYMDS'
WHERE TOTAL DOLLARS_PAID GT 0.00000001 -* Why I hate computers
ON TABLE HOLD
END
Sure can't blame WebFOCUS for this one, and I'd wager I can't even blame Microsoft. Adding and subtracting dollars and cents results in an amount smaller than one one-millionth of one cent, and WF dutifully reported it as not equal to 0.
Dollars to doughnuts this is an error in the chipset.
January 27, 2015, 03:15 PM
j.grossReal accounting system designers eschew floating-point.