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 09:31:59
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:
01515701
Views:
46
>>>But you did not want to (or preferred not to) move the pointer, something that COUNT FOR will do.
>>
>>Yes, that's true. But I have LOCATE command after COUNT is done, so everything seems to be OK.
>
>It seems to be OK, but it is not. The SQL command that Hugo gave you is a good way to do this. By using SET FILTER and COUNT and LOCATE you are causing the computer to do much more work than it should.

I can use SQL, but then I will need to use with buffering clause as I'm changing the bottom view.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform