Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to count records produced by a set filter statement?
Message
De
04/10/2001 13:37:44
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
FoxPro 2.x
Divers
Thread ID:
00564008
Message ID:
00564313
Vues:
16
>>>>>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...

Darn good point! I've been in FPW2.6 too long. Totally forgot about buffering. That means I'm going to have to look at the routines we have/use in FPW and make real sure that buffering doesn't bite us hard in VFP7.

Thanks Nadya, now I've got yet another bugaboo to check out! 8-)

It also means I don't have another way of counting. You're right!
Peter Adams
FoxPro Programmer
Compu-Mail

Heisenberg was probably right...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform