Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find number of records satisfying SET KEY
Message
From
01/07/2011 12:20:23
 
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:
01517063
Views:
107
>>>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.

Change your mind again and go with locate/found ;-)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform