Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete and Index Problem
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00106705
Message ID:
00107425
Views:
21
>>>If it works for you it's Ok, i just wonder how it can work, because "INDEX and REINDEX always ignore SET DELETED and index all records in the table" (VFP Help).
>>
>>Ed, I would guess she was doing a search for the ID code and the deleted record wasn't found with SET DELETED ON.
>>
>>Barbara
>
>Yes, but appending new record with this code will fire violation. Or she doesn't use primary/candidate key?

My interpretation (not necessarily correct) was that she was doing a search BEFORE the append blank, and the search was missing a key that was deleted.
Hopefully, she's got everything working now.
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform