>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.
Souldn't that scope be FOR? :
SUM (rate*SHARE/10000) TO cRate
FOR inv_no+salesman = m.ccinv + m.Slsman
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.