VFP-SQL respects SET DELETED status.
>snip...
>
>Are you sure? I thought I read awhile back in the UT that SQL ignores SET DELETED status. However when I tried to go back and search the archives on this I couldn't find the thread, so maybe I was just smokin. If I can trust that SQL will abide by SET DELETED ON then I don't need to worry I suppose.
>
>>Don't include DELETED() in Select. Instead SET DELETED ON. VFP will take care of rest.
Edward Pikman
Independent Consultant