Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Validate Database
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Validate Database
Miscellaneous
Thread ID:
00030684
Message ID:
00030684
Views:
75
I opened the a database with "OPEN DATABASE d:\vfp\vmp\vm.dbc EXCLUSIVE" and then executed "VALIDATE DATABASE". I got the following output:

Validate Database VM:
Rebuilding structural index.... Index rebuilt.
Object #32 (Relation 'Relation 1'): Cannot find associated Index referenced by this object.


What is object #32 ?????

I copied the database and tables to another directory. I opened the copied database with "OPEN DATABASE d:\vmpsample\vm.dbc EXCLUSIVE" and then executed "VALIDATE DATABASE". I got the following output:

Validate Database VM:
Rebuilding structural index.... Index rebuilt.
Object #11 (Table 'generatepk'): Invalid primary key property.
Object #17 (Table 'users'): Invalid primary key property.
Object #24 (Table 'userprefs'): Invalid primary key property.
Object #32 (Relation 'Relation 1'): Cannot find associated Index referenced by this object.
Object #33 (Table 'reportcatalog'): Invalid primary key property.
Object #43 (Table 'lookuptypes'): Invalid primary key property.
Object #52 (Table 'lookups'): Invalid primary key property.
Object #109 (Table 'statesprovinces'): Invalid primary key property.
Object #149 (Table 'parts'): Invalid primary key property.
Object #225 (Table 'invoices'): Invalid primary key property.
Object #262 (Table 'lineitems'): Invalid primary key property.

Why does copying a database to a different directory create all of these problems and what are all of these object numbers ???

Thanks in advance for any help.
Dennis Lindeman
Next
Reply
Map
View

Click here to load this message in the networking platform