General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only