Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbc corruption
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01199200
Message ID:
01199214
Views:
19
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform