Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find number of records satisfying SET KEY
Message
From
30/06/2011 16:01:11
James Blackburn
Qualty Design Systems, Inc.
Kuna, Idaho, United States
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01516912
Message ID:
01516919
Views:
48
select count(*) from table where (same condition as the set key) will give a count without changing your record pointer.

>>>Hi everybody,
>>>
>>>I made a change in my form to use SET KEY instead of original SET FILTER. Everything seems to be working OK, but I still have a question - how wll I know the number of records satisfying the KEY (e.g. the number of filtered records)?
>>>
>>>The _TALLY variable doesn't work.
>>>
>>>I actually only need to know if I filtered something or not, although I created a variable for the number of filtered records. So, I can change it to logical variable, if you know an easy way to find if I filtered something or not, although I prefer to have a number.
>>>
>>>Thanks a lot in advance.
>>
>>This gives you the "visible" count:
>>count to lnCount
>
>Yes, thanks - thought is there a way without a count? I guess I will go for it.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform