Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upsized VFP to SQL 7 - getting Invalid PK Property msg
Message
De
19/10/2000 13:18:12
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Upsized VFP to SQL 7 - getting Invalid PK Property msg
Divers
Thread ID:
00431596
Message ID:
00431596
Vues:
57
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform