>Hi Everybody,
>I was wondering if there is an easy way to create a subset array from a larger array data set.
>
>For Example the Large array data set would have the following: Supplier, Supplier ID and Part Number.
>
>I would like to create a second array with only the unique Suppliers from the larger data set.
>
>Thanks,
>Joseph Schaff
The easiest way would be to create cursor, then the array (if you don't want to use cursors), e.g. (field types are made up for example),
Create Cursor cu_tmp (supplier c(30), supplier_id i, part_number i)
Append From Array laLarge
Select Distinct supplier From cu_tmp Into Array laJustSuppliers
Insanity: Doing the same thing over and over and expecting different results.