>>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.
>
>check
>SET EXACT and SET ANSI setting
Hmmm, I checked that the length of the passed value is 4, though I only type three chars. I have MaxLenght property set to 4, but I do not see in the code where I add spaces at the end.
I guess I have to fix my form's code just to make sure I always pass 4 chars and not less.
If it's not broken, fix it until it is.
My Blog