>Any simple way to remove duplicates in a one dimensional array? No specific order to the rows and the elements are text. I'm thinking of looping through, and comparing elements, but the no-order thing has got me paused... Thanks!
>
>Regards, Renoir
Renoir,
I don't know how many items you have in the array, but my first thought is this:
create table temp (cElement c(20))
iterate through the elements and append to table
select * from temp ;
order by cElement ;
group by cElement into cursor tempCursor
create a newArray (or redimension old one, and reuse it)
scan/endscan through tempCursor and put into new array
Should work pretty quickly...
Steve Gibson