Terry Simpkins writes:
>We have a detail dataset with 5 keys into it.
>Logically, there should never be two records with the same 5 keys.
>Duplicates on up to 4 are OK, but not all 5.
>You guessed it, we have the condition.
>The question now is "what is the easiest way to find the duplicates"?
>
>Tools available: Query, Quiz
This might be the time to expand your repertoire a bit :-). Robelle's
Suprtool is great for doing this kind of thing, and also implementing the
fixes when done. One of my clients uses Suprtool for data repairs in data
bases, and it's amazing how quickly their technical guy can find bad
data, or odd-looking data, or funny patterns, and then fix them. He also
runs Suprtool jobs on a daily and weekly basis to audit the data and find
problems before they become widespread.
Without that, one alternative is to do a FIND ALL in Query, then do a
save, then use SORT, then inspect the result. (I'd use BASIC at this
point, if you have it.) Doubtless there's a way to use Quiz as well.
-- Bruce
--------------------------------------------------------------------------
Bruce Toback Tel: (602) 996-8601| My candle burns at both ends;
OPT, Inc. (800) 858-4507| It will not last the night;
11801 N. Tatum Blvd. Ste. 142 | But ah, my foes, and oh, my friends -
Phoenix AZ 85028 | It gives a lovely light.
btoback AT optc.com | -- Edna St. Vincent Millay
Unsolicited mail to [log in to unmask] will be inspected for a
fee of US$250. Mailing to said address constitutes agreement to
pay, including collection costs.
|