Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RecordCount after setting Filter
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Divers
Thread ID:
01461631
Message ID:
01461634
Vues:
72
>Is there a way to get a record count with a FILTER in effect? I mean a record count of all the items within the filter's limits? I know that RECCOUNT() will still count ALL records, not being affected by SET FILTER.
>
>The problem I am having is to be able to control the problem of EOF and BOF when there are no records within the FILTER setting, and then you hit the navigational buttons and erros jump up for BOF and EOF.
>
>Cecil

You can run a select statement with the same condition as a filter to get the number of records. Alternatively you can COUNT FOR the same condition as filter.

Finally, you can switch to a better technique than a filter.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform