I think it's a bad idea. If somebody changes where condition of the query or makes query not fully optimizable some other way, you'll get wrong result.
>Ah. The one thing I didn't try was with both ANSI and EXACT set ON, and the result is the sam as with them both set off. Then that answers the question. That being the case, then am I safe in doing what I'm doing in turning off EXACT and ANSI in order to keep the table's deleted flags set? Or do you think I'm playing with fire?
>
>>W/o NOFILTER VFP may create filtered cursor by applying SET FILTER/SET FIELDS to the source table opened similar to USE...AGAIN. It cannot be done when SET EXACT and SET ANSI doesn't match. I don't think it's documented anywhere.
--sb--