Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Count of records in filtered cursor?
Message
From
28/10/2001 01:02:22
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Count of records in filtered cursor?
Miscellaneous
Thread ID:
00574206
Message ID:
00574206
Views:
46
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?
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Next
Reply
Map
View

Click here to load this message in the networking platform