Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index missing - The .cdx file is deleted?????
Message
From
03/02/2005 05:10:54
 
 
To
02/02/2005 14:02:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00983107
Message ID:
00983378
Views:
11
>>Sounds like corruption. Try DELETE TAGS ALL and rebuilding them so that you start with a clean index file.
>>
>>Tamar
>
>Well see, that's the thing, I have a machine I setup bat files along with windows task manager to start at 11:00 PM and they go through each table of our program, copy it to a backup drive on the slave disk, delete the indexes, recreates each index, and then if nothing errors out, it copies them back online. This gives me a reindexed backup of each table and an online reindexed table to start with each day. The batch files have all ran through fine without errors for a while. So basically if it is getting corrupted, it is doing it every time this random whatever occurs since I have a fresh new index on them every day. Any other ideas?


If your tables are in a database then...
after completely rebuilding an index (Delete Tags All and so on) i would
Pack Database
Validate Database.

All the best.
Kamil
A moment of silence is our cosmic reset button.
Previous
Reply
Map
View

Click here to load this message in the networking platform