Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database error after changing referential integrity
Message
De
03/08/2005 09:57:58
 
 
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 SP3
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01037852
Message ID:
01038112
Vues:
28
>>>I have a database to which I added new tables. After I set the referential integrity I get an ".DBC internal consistency error". I then have to force shut down VFP.
>>>
>>>When I then try and access the database I get the following error "Index does not match the table. Delete the index file and recreate the index"
>>>
>>>How do I correct this and how do I know what index is corrupt?
>>>
>>>Thanks in Advance
>>
>>make a copy of the .DCX file
>>Delete the .DCX file, as the error message suggests
>>open the database exclusively
>>that will rebuild the DCX file
>>Validate the database
>
>I'm afraid, it would not help. Worth a try, anyway...

Why do you think so ? I remember having some of them back in the 3.0 days. I deleted the index and opening the database exclusively recreated the index
Gregory
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform