Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Upsized VFP to SQL 7 - getting Invalid PK Property msg
Message
From
19/10/2000 13:18:12
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Upsized VFP to SQL 7 - getting Invalid PK Property msg
Miscellaneous
Thread ID:
00431596
Message ID:
00431596
Views:
55
I've upsized a VFP 6 DBC to MS SQL 7 using the wizard w/o errors. I can open any table in the SQL 7 Query Analyzer and query fine. When my VFP app tries to open a table I get:

Object #nnn (Table 'tablename'): Invalid primary key property. Validate database.

If a table didn't have a PK defined when upsized, it's ok. Any table with an original PK defined gives this message and tells me to validate the database.

I deleted the pk in SQL Enterprise Manager but still get the error back on the client side. When I look at the table using Design Table | Table and Index Properties, there is nothing unusual.

How do I find what property is invalid?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform