Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to count records produced by a set filter statement?
Message
 
 
To
04/10/2001 13:17:13
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00564008
Message ID:
00564298
Views:
15
>>>>Hey Alexander - thanks - that did the trick!
>>>
>>>Hi Chris,
>>>I do this all the time and just COUNT in the command window will count all the records in your filter set. Make sure SET TALK ON and SET STATUS BAR ON.
>>>
>>>I also do subsets of the filter by
>>>
Count() for <i>condition</i>
>>>HTH a little more,
>>>Pete
>>
>>I'm wandering, is where another way besides COUNT. The filter itself would be slow, then COUNT - two slow commands to determine this number... :(
>
>Hi Nadya,
>
>Sure, SELECT fieldname, cnt(*), etc.
>
>but then, COUNT takes less time to type. Unless of course, you can type perfectly AND fast. Me, I can't do either... 8-\

SELECT would not respect buffered data. Actually, if bof() and eof() at the sime time, it means, that all records are filtered out...
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform