Android Question Jackcess library: order by...

[dibesw]

HI,
I'm using Jackcess library and is working well.
about this code...

Sub Activity_Create(FirstTime As Boolean)
    'Do not forget to load the layout file created with the visual designer. For example:
    listpaz.Initialize("listpaz")
    Activity.LoadLayout("Layout1")
    Access.Open(File.DirRootExternal & "/infostudio_tab.mdb")
    Table.Initialize(Access.GetTable("PATIENTS"))
    leggipaz
    Index.Initialize(Table.GetIndex("PrimaryKey"))
    'Index.Initialize(Table.GetIndex("NAME"))
    Cursor.Initialize(Table.GetTable, Index.GetIndex)
End Sub

Sub leggipaz
    ProgressDialogShow("Attendere...")
    Table.Reset
    For i = 0 To Table.GetRowCount - 1
        Table.GetNextRow
        listpaz.AddSingleLine2(Table.GetColumnValue("NAME"),Table.GetColumnValue("CODE_PAT"))
    Next
    ProgressDialogHide
End Sub

.. I have list of patient name but is not in alphabetical order.
How to create a query sorted?

Thanks in advance.

 

[Erel]

You can add all the elements to a List, sort the list and then add the elements to the ListView.

You can create a custom type that holds both fields and call List.SortType.

 

[dibesw]

Great! I had not thought of this. Thanks Erel.