Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
UNIQUE INDEX FILTER
Message
De
30/11/2000 08:24:23
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00447200
Message ID:
00447254
Vues:
9
>I ran into a particular problem that I have trying to figure it out.
>
>I have a table with a primary index.
>I can add to the table. If I delete the record and cannot add another record.
>I get the Error Index Uniqueness. If I pack the table. I can add the record.
>Then I start the process again.
>
>I have set delete on -- does not work in this problem.
>
>What I ended up doing was to add to the filter option of the index
>tag the expression !DELETED().
>
>This allowed me to by passed my problem
>
>However, I have a question.
>
> Is this approach correct or is there a better way?
>
>Manny

As Larry said, you should not reuse primary keys. There is a KB article on my web site that discusses this and provides code to generate new PKs.
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