Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to count records produced by a set filter statement?
Message
From
04/10/2001 13:17:13
 
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00564008
Message ID:
00564290
Views:
13
>>>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-\
Peter Adams
FoxPro Programmer
Compu-Mail

Heisenberg was probably right...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform