Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary key and referential integrity verifier
Message
From
15/04/1999 15:26:57
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Primary key and referential integrity verifier
Miscellaneous
Thread ID:
00208734
Message ID:
00208734
Views:
59
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
Next
Reply
Map
View

Click here to load this message in the networking platform