While your problem description doesn't belie it, you might try removing the TAG on DELETED() in the base table if there is one.

good luck


>I am doing a requery of a view that is based on a large file and when I execute my code the requery sometimes takes up to 10 minutes to return.
>When I put in a "set step on" before the requery the requery finishes in about 10 seconds. I am using VFP 7.0 and my view is based off of an SQL table.
>Has anyone ever experienced anything like this ?
>
>Thanks for your help !
>Stephen J. Hunt