Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Primary key property is invalid - need help please
I am working remotely via Laplink onto a host that is running a VFP6 exe. They were getting internal consistency errors when shipping from the app. I decided to rebuild the cdxs for the 2 invoice tables. Well...I opened the detail table and delete tag all. Then rebuilt the tags with the index on commands. I made one of the indexes a primary key as it was before by using the Alter table command. That worked great.
Next I tried the same on the header file. Can't get it to open "Primary key property is invalid. Please validate database". When I validate the database, it essentially tells me the same thing and I still can't get it.
Unfortunately, they only have the exe (although it does have an option to use the command line but I can't modi the database from there.
I downloaded it all and can modi the database but can't get in to the header table (same error). I opened the dbc and deleted all recs for the header table. Modi the database again and it is gone but I can't add it back because it says it is already part of the dbc.
Any help would be great!!!
Sally
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement