Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Validate Database
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Validate Database
Divers
Thread ID:
00030684
Message ID:
00030684
Vues:
73
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform