DBC error after change RI  
Author Message
Ludek





PostPosted: Visual FoxPro General, DBC error after change RI Top

Hello,

FoxPro 9.0 SP 1 - DBC database:
after change referential integrity - update or delete restriction, save changes is displayed window with ".DBC internal consistency error". I must end foxpro task end recover database from backup.
1. I validate database (recover) - DBC error
2. I delete index file *.dct - DBC error
Thank You Ludek



Visual FoxPro1  
 
 
Garrett Fitzgerald





PostPosted: Visual FoxPro General, DBC error after change RI Top

FoxPro 9.0 SP 1 - DBC database:
after change referential integrity - update or delete restriction, save changes is displayed window with ".DBC internal consistency error". I must end foxpro task end recover database from backup.
1. I validate database (recover) - DBC error
2. I delete index file *.dct - DBC error

Ouch. The .DCT isn't the index file: it's the memo file, like an FPT. The .DCX is the index file.


 
 
WLBlakeshaw





PostPosted: Visual FoxPro General, DBC error after change RI Top

I've been running into this recently. I'm going to delete my foxuser table and see if that corrects the problem. This happened to me whether or not I had a project open (sometimes having the project open seems to cause this). In my case even if I deleted the dcx, I would then get an error about the memo file being corrupt as well (and therefore you're hosed).
 
 
Naomi Nosonovsky





PostPosted: Visual FoxPro General, DBC error after change RI Top

I had this problem before multiple times. With VFP8 the problem with database was ucurable, with VFP9 we were able to fix the database after that error.

Anyway, before running RI you need to do these important steps:

1. Backup your database

2. Run command

open myDatabase exclusive

PACK DATABASE

COMPILE DATABASE

3. Now you can run RI without a risk of Internal Consistency error.