Android Question keyvaluestore , listkeys question

[tufanv]

HEllo,

When I add a kvs's all the keys to a list they are added alphabetically , is it possible to list them according to row number like : last added will be last and first added will be first . I checked this code:

Public Sub ListKeys As List
    Dim c As ResultSet = sql1.ExecQuery("SELECT key FROM main")
    Dim res As List
    res.Initialize
    Do While c.NextRow
        res.Add(c.GetString2(0))
    Loop
    c.Close
    Return res
End Sub

but I couldnt find why it lists the alphabetically as "select key from main" must not sort them like this.

TY

 

[Mahares]

last added will be last and first added will be first

Try this,

Dim c As ResultSet = sql1.ExecQuery("SELECT key FROM main ORDER BY rowid")

 

[tufanv]

Try this,

Dim c As ResultSet = sql1.ExecQuery("SELECT key FROM main ORDER BY rowid")

yes works perfect thanks. I didnt know that we could use rowid for sorting with rownumber