Re: Optimization Level
From: Cindy Winegarden (cindy.winegarden_at_mvps.org)
Date: Wed, 24 Mar 2004 10:56:53 -0500
In news: OCVYaQbEEHA.2548@TK2MSFTNGP12.phx.gbl,
Michael Shaw <firstname.lastname@example.org> wrote:
> I have tried the same query with set deleted off and the query reports
> 'Full' as expected.
> I am not sure why deleted has to be 'off' when there are no deleted
> records in the table.
Test your optimization with Deleted off and if you get "Full" you'll know
you've got everything set right. Then change Deleted to whatever you usually
-- Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP email@example.com www.cindywinegarden.com