Sort field values with GetRows function

[nwlanding]

For a series of 12 fields returned in a GetRows funtion I need to rank each of the field values in descending order for each record and perform specific updates based on the results. I thought about creating an array out of the field values and iterating through each value and ranking them but I thought I'd check to see if there's an easier method that I'm not aware of.

Thanks...

 

[Marryp]

Try using the listview control

 

[cmmrfrds]

Assuming you have a static ADO recordset with a client side cursor. Instead of using the GetRows function, disconnect the recordset and use the ADO sort. You could sort on the first column either desc or asc then handle that column and then repeat for the other columns. I believe this would be easier to follow, require less code, and still be quite efficient.