Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Dbc corruption
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01199200
Message ID:
01199214
Vues:
18
>>I've been having a problem with data base corruption when I build referential integrity into it using the data environment. Anyone else having this issue? It doesn't matter if I access the dbc on my laptop or another drive. I selected one table which had a relationship and selected "referential integrity", then seleced "cascade" for deletes and saved, and immediately got the .dbc corruption message....
>
>I had such a problem.
>What I did:
>1. Open database as table exclusive
>2. SELECT * from database into cursor crsTest NOFILTER
>3. ZAP database
>4. INSERT INTO DATABASE;
> SELECT * from crsTest
>
>Be sure you have a very good backup first.

I'll give that a try. I thought it might have had to do with my resource file, so I deleted it and tried again. It still corrupted. I also validated the database, packed the dbc and still got the same results. I'll give your suggestion a shot.
John Harvey
Shelbynet.com

"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform