Check the file dictionary to see if the conversion is set to MD0. If so, the value will round up to 1679. Change it to MD2 and you should get the correct result.
Ron Babic Marinko wrote:
Hello I have a single value field EX.NUMBER with the following values: Key EX.NUMBER A 123.45 B 567.89 C 987.65 The result of the following SQL Statement using BCI (UniVerse BASIC SQL Client Interface) is SELECT SUM(EX.NUMBER) FROM YYEXAMPLE USING DICT DYYEXAMPLE; Result: 1679 The result should be 1678.99. The statement PRECISION 4 does not affect the result. Any idea? Kind regards, Marinko ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
