Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unique Index Key - Delete record and add the same again
Message
De
11/07/1996 12:25:57
 
 
À
11/07/1996 12:21:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00003428
Message ID:
00003777
Vues:
28
>Andreas,
>
>According to the Microsoft Knowledge Base (Article ID: q139756), you must create a filtered index in order to reuse deleted keys. They suggest using the following expression for the primary key index filter: !DELETED()
>
>Incidentally, I had the same problem and this solution worked for me without a noticeable decrease in performance.
>
just a note:

it is better to set an index on DELETED() rather than
on !DELETED() because the first is rushmore optimizable and
the latter is not

Arnon
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform