Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Validate Database
Message
De
02/05/1997 15:49:47
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00030684
Message ID:
00030685
Vues:
30
>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.

If you open DBC file like simple table: USE data1.dbc
you will see ObjectId field from where all # were taken.
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform