Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What if .cdx goes south and we have (had) Primary Key?
Message
From
19/08/1997 16:13:08
Matt Mc Donnell
Mc Donnell Software Consulting
Boston, Massachusetts, United States
 
 
To
19/08/1997 16:00:09
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00045638
Message ID:
00045645
Views:
41
OK Dragan, it may take me a minute or two to catch up, so bear with me....

Is this index recovery something you want to happen all the time? How often are you seeing file corruption?

If this is something that will only run, say, nightly or even weekly, then we can assume that it is going to be a primarily administrative task. That being the case, we should be able to get exclusive access to the DBC...correct? (I certainly hope so.)

In this case, if the indices were maintained up until the time of the corruption, then data integrity (PK) should be OK. At this point, if you wipe out the index in question and the indices on any children and the open then corresponding tables using an error handler to capture missing cdx errors, shouldn't you be able to rebuild the indices without having to do any low-level manipulation?
Matt McDonnell
...building a better mousetrap with moldy cheese...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform