Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count for respects filter settings ??
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00148471
Message ID:
00148496
Views:
17
>Hi,
>
>I was surpriced to see that COUNT FOR respects the filter settings of a DBF. Is this always the case or is there some way to use COUNT FOR on an entire DBF without removing the filter?
>
>We have a DBF with Companies. We want to show the user a list of companies connected to him in a specific city (filter on two fields), and at the same show the entire number of companies in this city (COUNT FOR on one field).

You can always do an SQL for counting, it ignores filtering...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Reply
Map
View

Click here to load this message in the networking platform