General information
Category:
Coding, syntax & commands
>>>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only