Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Validate and repair a database and tables
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00178838
Message ID:
00178843
Views:
29
>Hi, all
>Anybody know the way to make a class or function to validate a database and repair it if isn't valid ???
>
>I know that the Validate Database Recover is only for the command windows and we can't able to do it programmaticaly. Another way ????
>
>Thanks for your time

You could probable write it yourself with a combination of the following methods:

open the dbc as a table, and scan through it.
for every
field: test its existence in its table or view
table: make sure it exists and that it belongs to the database
index: make sure its expression is valid and that the table knows about it
relations: well, your on your own here.

I have never done this before, but it should be fairly straightforward. For records in the dbc that fail the test, delete them, or do what you see fit.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform