Hi everybody,
I have a loop, where some updates are done on Comision table in non-buffered mode.
I recently changed my code to select sum(...) and I found a difference in my results. So, I switched back to sum ... Why would the results of these two commands differ?
SELECT SUM(rate*SHARE/10000) AS crate WHERE inv_no+salesman = m.ccinv + m.Slsman ;
FROM comision INTO ARRAY laArr
SUM (rate*SHARE/10000) TO cRate WHILE inv_no+salesman = m.ccinv + m.Slsman
(I'm standing on the right record).
Thanks in advance.
If it's not broken, fix it until it is.
My Blog