>>>>Hi
>>>>
>>>>I remember an issue where reccount() could be misleading after a query is not using nofilter. Anyone else remember that or have an example. Or am I just wrong.
>>>>
>>>>
>>>>Thanks
>>>>
>>>>Nick Mason
>>>
>>>You're right, use nofilter.
>>>Cetin
>>Hi Cetin
>>
>>I thought one argument against automatically using nofilter is that it can be slower as recorda hev to be physically written everytime. I usually check _TALLY to find how many records have been selected. Do you think that is always accurate.
>>
>>Nick Mason
>
>Nick,
>If I say no then some lurkers would request reproducable code:) I know that it doesn't work right 100% but do not have reproducable code just at the moment so I prefer to say yes (also from version to version reliability matters). I think you'd never see its problems, using collating machine and English only.
>Cetin

I've always regarded _TALLY as certain so I'd be interested in examples of it not being correct.
I've just had pointed out to me the change in vfp9 where a sum select will produce a NULL and a tally of 1 if no records match.

Nick