>>>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
>
>No, while will work since in the preceeding line of code (not shown here) I seek for m.ccinv + m.Slsman
>
>I haven't figured why I was getting different results, but I decided to move on.

Check COUNT(*) vs COUNT, are they equals.