>>>>>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
Nick,
Your VFP version is at least 7 right? If so don't worry, it works. It's now very hard for me to remember the faulty version + prepare reproducing code. If there were chance to search in last 10 years I have posted it before but when God knows.
Cetin