>Hello guys!!!!
>i have a 1.5 GB table in shared mode. can anybody tell me why in the H*** the first time I run "SET FILTER TO .F. " it takes 5 minutes? should i use somekind of buffering that i don't know?? would it help?
>
>thanks,
>ionut
because VFP scan the whole table to find the first not filtered record.
with .F. VFP cannot use a index (optimize) for the expression.
define a index for the ePK (Primary key )
and
SET FILTER TO ISNULL(ePK)