I have a vfp database or custom data dictionary which has primary and candidate keys and referential integrity (some fields must be present in master table fields) defined.
For some reason (part of dbfs are overwritten and file replacing)
database integrity is violated.
I need to check the report of violations and, if possible auto-repair them. Is there a such
utility which allows to re-check, report and repair database
integrity. I checked vfp ja SDT but haven't find such possibility.
In real working system, during reindexing a message
"uniqueness on index violated" appears and index will not created.
This stops the program at all.
Andrus