Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SET DELETED ON???
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00217935
Message ID:
00218442
Views:
25
Ken,

I'm not the one who had the problem. I just jumped in to say that I was surprised that so many people (including some acknowledged gurus) were telling the person to use SCAN FOR NOT DELETED() when he said he had DELETED ON.

Thanks anyway,
Rich.

>Hiya Rich,
>
>I believe your record pointer is not moving off the deleted record and that is why you're seeing it. By bypassing the endscan, you're also bypassing the implied skip that goes along with it. Try putting a ? recno() in the loop and you should see what I mean. I agree with the others here that have already said that scan for not deleted() would be a better approach.
>
>>>Steve,
>>> [snip]
>>>2) I'd add a not DELETED() to the SCAN for clause
>>
>>I'm confused. Lots of people besides Jim have said this.
>>
>>If SET DELETED is ON, SCAN is already SCAN FOR NOT DELETED(). Or what am I missing?
>>
>>- Rich.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform