DBC error after change RI

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

Ludek wrote:
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.

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).

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.