Skip to Content
0
Former Member
Dec 07, 2009 at 01:29 PM

descending order not getting worked up

20 Views

Hi All,

       Dim Dtatable As SAPbouiCOM.DataTable
        tGrid = tForm.Items.Item("1").Specific
        Dtatable = tForm.DataSources.DataTables.Add("dtTemp")
        Dtatable = tForm.DataSources.DataTables.Item("dtTemp")

       strQuery = "Select * from EMP order by Hire Date desc"    <---------

        tGrid.DataTable = Dtatable
        tGrid.DataTable.ExecuteQuery(strQuery)
        tGrid.CollapseLevel = 1
        tGrid.SelectionMode = SAPbouiCOM.BoMatrixSelect.ms_Auto

In the above code iam showing the employee data based on hire date in a new history window,now my problem is iam unable to show the employee data based on hire date on DESCENDING ORDER as ascending order is getting worked up properly but for DESC the data is getting displayed as ascending only.can anybody suggest me some ideas to solve this problem.

thanks

dileep varma s