Hi Fabio,

Yes, the possibility to use the FOR !DELETED() TAG and still be rushmore optimizable is the best way. This is certainly a usefull enhancement found in VFP9. This should put an end to the dreaded DELETED() tag.

Walter,




>Hi Walter,
>
>i agree with you.
>
>The only way in order to take advantage of the DELETED() flag
>in the indices is that one to improve VFP:
>- if SET('DELETED')==' ON'
>then, when VFP optimizes a command, VFP uses the indices like this:
>

> INDEX ON keyexp FOR !DELETED()
>

>else, apply current VFP rules.
>
>Fabio