Hi Barry,

Did you use

PACK DATABASE
and
COMPILE DATABASE before running RI builder?

Without doing this you would get an error.

Now, if your database is already corrupted, perhaps you can re-create it using GenDBC and append from all tables. You can create RI code separately (remove this part for now).

These are the ideas to try.

>Naomi,
>
>I am using V9.
>
>I have run the VALIDATE and it reports Database container is valid.
>
>I can access the RI builder and set the conditions, but when I try to save the changes I get the error.
>
>I have made several changes to the dbc over recent months, but not to the RI aspect. I have tried re-loading previous backups, but all show the same error. The internal consistency error must have crept in some time ago - but it does not seem to be affecting the working of the application. Except that I can not introduce some new RI.
>
>Barry.
>
>
>>What is your VFP version? In VFP8 this error pretty much meant, that you now need to restore from the backup.
>>
>>In VFP9 we were able to recover from this error using VALIDATE DATABASE RECOVER.
>>
>>In any case, before attempting to change RI, always do the following:
>>
>>1. Make a backup
>>
>>2. OPEN DATBASE myDATA EXCLUSIVE
>> COMPILE DATABASE
>> PACK DATABASE
>> re-build RI
>>
>>>After editing referential integrity and trying to save I get the above error message. I have tried VALIDATE DATABASE and I have also deleted the .dcx index file as suggested in the help file and opened up the dbc again when the index is rebuilt, but to no avail. The 3rd Help suggestion ("call Microsoft support") does not fill me with joy.
>>>
>>>And to make matters worse, the only way I can then quit VFP is to shut it down in task manager. Groan.
>>>
>>>Any help greatly appreciated.
>>>
>>>Barry Sutton.