Need Distinct Values

[Kenneth Brody]

Quoting Walter Vaughan (Tue, 16 Jan 2007 17:23:24 -0500):
[...]
> I have about 17K records with two fields, one 10 characters and one 2.
> I need to create an xml export with unique values.
>
> Of course as you can see from the following code snippit, it's only good
> for 2,666 values and I need seven times that.
[...]
>    3  -------   -   -   -   -   -   -   -   -
>         . If: 'combine fields ala MK12-2345-89
>         Then: pm=mid(1,"1","2"){6
>    4  -------   -   -   -   -   -   -   -   -
>         . If: zm co pm
>         Then: end
[...]
> And as expected I am getting duplicate keys in my xml export since "ZM"
> can't be made larger than 32K. The XML records are way wider than 255
> characters so I can't use a report format.
>
> How else can you remove duplicate output data at runtime?

Can you sort on field 1 for length 2, and then field 6?  Any duplicates
will then be in consecutive records.

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com