Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Easy question!
Message
From
27/08/1999 12:36:42
 
 
To
27/08/1999 12:34:53
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00258196
Message ID:
00258488
Views:
14
>
>>
>>Use the NOFILTER clause with your select statement. For speed purposes, when it can, VFP dresses up a copy of the base table with a filter to give you your result set. The NOFILTER clause ensures that the result set has a real disk presence, instead of being the base table in disguise.
>
>
>Thanks to all of you, it works now.
>Isn't that strange to mention "nofilter" to see a reduced set of the table when the cursor was in my opinon already a filtered view from the table!!!!
>
>Also, if the grid sourcetype is cursor and I do :

>SET FILTER TO condition
in the load method of the form it works. Is it a good practice?
>
>Claude

It's fine, if the filter is optimized. I personally hardly ever use SET FILTER, but use views instead.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform