VB6 Sort HELP

[bdannels]

Hello:

I am very new to VB6, trying to do a datagrid sort with some VB code on a mySql database that is on my web site via ODBC.

The DataGrid is connected and working I can see all the fields on the database.

When I run the code listed below, it just sits there, nothing moves.

I am quite sure I am doing something wrong, but don't have a clue as to what it is.

Any help sure would be appreciated.

Tks.
Bill
-------------------------------------------------------------------------------------
Private Sub cmdTestSort2_Click()
Dim strQuery As String
strQuery = "SELECT * FROM proofrequest ORDER BY myCallback ='Y'"
Adodc1.RecordSource = strQuery
DataGrid1.Refresh
End Sub

[Mahesh_Bote]

after refreshing the grid, have u re-fill the grid? if no, the call the Fucntion or Sub Routine to fill the grid.

Mahesh

[bdannels]

Mahesh:

Thanks for the quick reply.
Not really sure how to do that, could you show me how to do it, in my code.

I sure would appreciate it, thanks again.

Bill

[Mahesh_Bote]

Private Sub cmdTestSort2_Click()
Dim strQuery As String
strQuery = "SELECT * FROM proofrequest ORDER BY myCallback ='Y'"
Adodc1.RecordSource = strQuery
DataGrid1.Refresh
' --- Call the function or sub routine here, which u used to fill the grid
Call FillGrid
End Sub

or let me know, how u fill the grid?

Mahesh

[bdannels]

Mahesh:

The sort code listed below works BUT it uses a "Recordset.Filter "
I do Not want to use the filter method.

The refresh fills the grid through the adodc as far as I know. It should work the same as the first sort code I posted but something is missing :(

Thanks again
Bill

Private Sub cmdSortbyCallBack_Click()
Dim strQuery As String
strQuery = "SELECT * FROM proofrequest ORDER BY myCallBack DESC"
Adodc1.Recordset.Filter = "myCallback='Y'"
Adodc1.RecordSource = strQuery
DataGrid1.Refresh
End Sub

[fplesco]

Hello bdannels -

My observation to your problem is this:

strQuery = "SELECT * FROM proofrequest ORDER BY myCallback ='Y'"

is good

and can also be written
strQuery = "SELECT * FROM proofrequest ORDER BY myCallback ='Y' ASC"

Notice the ASC keyword which is the default for all ORDER BY clause. Since you had not specify the order (DESC or ASC), it has been defaulted to ASC.

It seems to me that, when you have initially filled your datagrid object with data from the database, same query had been executed. And that explains why you seemed to look at the data exactly the same as you previously loaded, nothing changes as you look at it.

My recommendation is, try this code

strQuery = "SELECT * FROM proofrequest ORDER BY myCallback ='Y' DESC"

and omit the Adodc1.Recordset.Filter = "myCallback='Y'"
...

As to your original code, just add a keyword DESC to your query, nothing else changes.