Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DBC Internal Consistency Error
Message
De
01/06/2002 19:33:17
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00663752
Message ID:
00663831
Vues:
11
>Hi,
>I am running a program that does the following:
> - Zap records in MyTable
> - Append records from a .TXT file
> - Delete certiain index tags
> - Replace certain field with new values
> - Recreate deleted index tags
> - Close MyTable
>
>At one point, I get this error - 1550, DBC Internal consistency error. I looked at the Microsoft website and they suggest that I use Validate Database command. I will try this.
>
>I would really appreciate it, if anyone could provide me more insight into this problem.

VALIDATE DATABASE RECOVER is a good place to start (after backing up the .DBC and related files). A .DBC is simply a table so you may PACK or REINDEX it.

One thing to be careful of is if you have relations set in the .DBC that involve the table whose index tags you are deleting. This will break those relations in the .DBC and might be the root cause of what you're seeing there. If that's the case you might need to drop, then rebuild relations using ALTER TABLE ... REFERENCES.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform