Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RecordCount after setting Filter
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01461631
Message ID:
01461634
Views:
71
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform