>
>>
>>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