Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEX problem
Message
From
27/08/1997 18:45:11
 
 
To
27/08/1997 18:42:49
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00047222
Message ID:
00047237
Views:
29
>>>> I have a problem with my customers. Some user of my software don't know about computer and Win95. Some of them shut off the computer when software is running (if you tell the user to never shut off the computer like this, somebody else are going to do it!!!). Some of them kick the power bar. Some of them are going out by the only way they know, the old Ctrl-Alt-Del key.
>>>>
>>>>When this append, some or all CDX (index) are corrupted. I try the VALIDATE DATABASE command, some times with the RECOVER option, I try to REINDEX, but I can’t recover all. I can't beleave I have to do a program to manage this. I realy need help on this, because I am losing a lot of time to recover the data.
>>>
>>>In a situation like this, you really need some way of recovery. Also, from what you mentioned, it seems like this is not in a server environment which may explains that the user has the control to corrupt the files because they are stored locally.
>>>
>>>1. I would do daily backups
>>>
>>>2. Always avoid REINDEX, you need to DELETE TAG ALL and index all the tags again. Try to implement some indexing functions the users may use when this happen. In most cases, it is related to the index and this will let the user rebuilt them
>>>
>>>3. Get some utilities like Foxfix or more power like DSalvage
>>
>>Does DSalvage work fine with VFP?
>
>This was something I was about to add. No, I don't think it is ready yet for Visual FoxPro. It was mostly to give some examples of utilities for point 3.

Thanks. When I saw your picture I almost answered the phone! :)

Vlad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform