Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Ed,
>Don't recirculate keys is the best solution. AN alternative that gives some partial success is to embed a FOR clause in the index, but recreation of the index can be an issue, it will not be usable for Rushmore optimization, and should you ever try to recall a recirculated key or do not properly regulate reallocation of n out-of-sequence key in recirculation, you invite lots of trouble. You also create problems if you ever move from the native VFP file system, whose concept of records flagged as deleted but still present is not very portable.
Hmmm, When upgrading I wonder why you should include deleted records? If you don't upgrade the deleted records this should not be a problem at all.
Walter,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement