General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only