How can I get the same effect as an Order By query on an existing CachedRowSet?

Joe Sam Shirah

Remember that RowSets are extensions of ResultSets and were not designed as mini-databases. Probably the easiest way to handle new orders is to use the toCollection method, create an ordered Collection and work off the data from there.

The other way would be to read the data ( possibly again into a Collection ) sort it and then create a new RowSet using the insertRow method or with your own Reader.

0 Comments  (click to add your comment)
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.