Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary index with filter; can this be programmed???
Message
 
À
17/08/1999 08:47:32
Wim Dieke
Tranquility Bv
Almere, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00254466
Message ID:
00254503
Vues:
25
Wim,

There is no way to programatically create a filtered Primary index.

It is not good desing to do that anyway as you create a sitauation where the recall of an existing record could cause data integrity to be lost. Instead use surrogate pk's that are meaningless and never reuse a value for the PK. This way you don't care what the PK values are on the deleted records because you will never use them again anyway.

You can use candidate keys for those fields that must be unique.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform