Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find number of records satisfying SET KEY
Message
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:
01516940
Views:
59
>>>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.
>>
>>
>>SET KEY TO {Your Key Value}
>>GO TOP
>>
>>? EOF()
>>
>
>I think I'll go with that and change my property's name.
>
>UPDATE. I've changed my mind and went with the count.

Hi Naomi,

It is your mind to change, so change it as you seem fit, but take into account that the only thing you need to do is check for eof(alias), as the go top should be there anyways when you set a filter (or a key) in order to be make the filter take effect.
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Reply
Map
View

Click here to load this message in the networking platform