Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index missing - The .cdx file is deleted?????
Message
De
02/02/2005 14:02:17
 
 
À
02/02/2005 13:14:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
00983107
Message ID:
00983166
Vues:
17
>>I actually got more details on the case. It seems that the program displays "Structural Index file" not found or something to that line. Here is the weird part... I guess the file is actually there, it has the same file size as the restored cdx file would, but if you go to the command box and use it, it will let you use without error box, but you see no indexes in it. To get even stranger, when you rebuild the first index of about 6 or 7, as soon as the first one has been rebuilt, the other ones show up fine and everything is back to normal. Any ideas?
>
>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?
``` Appreciate a normal day, it is always better than a bad one ```

Kev
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform