Array Grouping

[jmancuso]

I'm trying to group the results within an array which is being populated by a dataset. For reasons outside of the scope of this forum I can't group within the query populating the dataset.

Example from Recordset
a
a
a
b
c

Example of Array values
a
b
c

Thanks for your help.

 

[JuggaloBrotha]

as you fill the array you should check the new value to be added against the current values that are already in the array (a simple loop can do this) if there isnt a value in the array equal to the new value then add the new value

if the value is already in the array then dont add it, move to the next value to add