Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count of records in filtered cursor?
Message
 
 
To
28/10/2001 01:02:22
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00574206
Message ID:
00574235
Views:
25
Hi Piter,

The status bar shows RECNO()/RECCOUNT() of the current workarea which are not affected by set filter. AFAIK, the COUNT command is only way to get number of records in the filtered set. Did you consider using SQL Select instead of SET FILTER? If conditions are Rushmore optimizable you'll get filtered set but _TALLY will have the number of records in it.

>I have a very changeable cursor that is based off of what is typed (interactively) in a text box... it limits the displayed records to text matches of 3 different fields in the cursor. I would like to return the number of records that are display (matches) as this changes. I have it working by calling an identical COUNT FOR expression TO where the expression is the same as the filter expression and storing the result in the TO. It just seems that there might be a quicker, less cpu taxing, way of doing that... like a reccount() except that only shows ALL records in the table, not the filtered ones. I noticed when I was running this from the Project Manager that the status line listed #### records as I ran the form. This appears to be the number of records in the filtered set... where does THAT come from then?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform