Sort with oracle

[deep]

Hi guys,
I am working on an application with VB6 as the frontend and oracle as the backend. I have made a connection through ADO(OLEDB provider). I want to do a sort on one of the fields of a recordset. Can i do it with oracle? if so can anyone please give me the code string.
I also have another problem. I have a form in which the controls display the fields of a recordset. I want to display a message like "do you want to save the changes" only when the user has changed field. I tried using the lost_focus event with the dataChanged property.
The code that i have is:


Private Sub txtCar_Model_LostFocus()

If (iMode = 1) And (txtCar_Model.DataChanged) Then 'if it is in the edit mode
If (MsgBox("Do you want to save the changes", vbYesNo) = vbYes) Then
Call update_EditMode("Car_Model")
Else
Call NormalColor
Call locControls
iMode = 0
Exit Sub
End If
End If
End Sub

But somehow, the msgbox gets fired even when i do not make any changes.Is the code right?

[kovan]

do a order by
example

SQL = "SELECT * FROM BraTable ORDER BY BraSize"