Hi Chaim,
check whole thread#
1072776 >I've found a change in behavior between VFP 8.0 and VFP 9.1 (I did not test this in VFP 9.0). Is this an intended change in behavior? This does not appear in Hentzenwerke's "What's New In 9":
>
>For this statement:
> SELECT SUM(nMyColumn) FROM MyTable WHERE MyCondition ...
>
>When no rows exist that satisfy MyCondition,
>
>VFP 8.0 returns: _TALLY = 0
>
>VFP 9.1 returns: _Tally = 1, the returned result is .NULL.
>
>Is this the way it's supposed to work now?
>If so, this will 'break' a lot of existing code.
>
>Thanks.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst