Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary key property is invalid - need help please
Message
From
02/09/1999 09:00:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Primary key property is invalid - need help please
Miscellaneous
Thread ID:
00260544
Message ID:
00260544
Views:
120
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
Map
View

Click here to load this message in the networking platform