Sorting a disconnected recordset

[roycet]

I am doing this:

(1) obtaining a recorset via an SQL string, with the ORDER BY clause already set
(2) modifying the recordset
(3) displaying the new recordset
Does anyone know of a good way to sort this disconnected recordset between steps (2) and (3)? [sig][/sig]

 

[khorjak]

This is an example from MSDN for sorting disconnected recordsets:

Dim cnn As New ADODB.Connection
Dim rst As New ADODB.Recordset

rst.CursorLocation = adUseClient
cnn.Open "DSN=Pubs;Provider=MSDASQL;uid=sa;pwd=;"
rst.Open "SELECT * FROM Authors", cnn, _
adOpenStatic, adLockReadOnly, adCmdText

rst.Sort = "au_lname ASC, au_fname ASC"

rst.Sort = "au_lname DESC, au_fname ASC"

rst.Close
cnn.Close

HTH [sig]<p>Choo Khor<br><a href=mailto:choo.khor@intelebill.com>choo.khor@intelebill.com</a><br>[/sig]