Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with duplicated primary key
Message
De
27/09/1999 10:48:49
 
 
À
27/09/1999 10:25:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00269314
Message ID:
00269345
Vues:
19
>Hi!
>I have a problem when I need to create a new record with a primary key equal to the pk of a record deleted (marked for deleted - not packed the table). Of course I need that field with the attribute unique due to the relational model. How can I create a new record without packing the table or renaming the pk?

If you are reusing PKs, you technically don't have them. The PK should be system generated. The user never needs to see it. If you need more information, see the KB article on my web site.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform