Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Naomi,
>Check Eliminating duplicates in a table FAQ #8129
I just glanced over your FAQ, and your method 2 seems to use too elaborate
code for the way to process (not totally sure, before my first coffe<g>)
I am quite sure you can get by with no second table just by scanning the ordered testDupe
table and using the "compare" memvar. Eliminates all seeking, and you are elimianting
in the order given by dupe, which should be identical to testdupe with order set.
Perhaps a "delete while" instead of the second scan loop can make the code even easier -
check where the recordpointer is after the delete while, as I am not sure the outer
scan makes code easier than the normally slower "do while !eof()" as we have record pointer
movement inside the loop.
Sorry to be imprecise, but I know you have no problem to fiddle a bit with your own code ;-)
regards
thomas
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