General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Upsized VFP to SQL 7 - getting Invalid PK Property msg
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
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