Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Way to find out if filter results in records
Message
 
 
To
23/06/2011 13:34:44
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01515632
Message ID:
01515731
Views:
36
>>>>Yes, that's true. But I have LOCATE command after COUNT is done, so everything seems to be OK.
>>>
>>>If you would add an index to the cursor or table in the bottom grid, you could use SET KEY TO instead of SET FILTER for the best speed. If the cursor is at EOF in the bottom grid, there are no matching records to validate.
>>
>>I need to filter based on combination of two integer fields. I think I did consider SET KEY originally when I designed the form, but at the end decided otherwise and used SET FILTER. Since it's working and in production, I don't want to do a major overhaul.
>
>No excuses. You can convert two integers into strings and index on that. It's no major overhaul.

Easy for you to say.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform