Android Question Best way to make a copy of ResultSet

Roycefer said:

I'm not sure how your database is structured or what your use case is but you might be able to work with a List of Lists or a List of Maps.

B4X:

'List of Lists, each row is a List, you will access each element by its index
    Dim r As ResultSet = ....
    Dim Results As List
    Results.Initialize
    Do While r.NextRow
        Dim row As List
        row.Initialize
        For j = 0 To r.ColumnCount-1
            row.Add(r.GetString2(j))
        Next
        Results.Add(row)
    Loop
r.Close

B4X:

'List of Maps, each row is a Map, you will access elements by their column name
    Dim r As ResultSet = ...
    Dim Results As List
    Results.Initialize
    Do While r.NextRow
        Dim row As Map
        row.Initialize
        For j = 0 To r.ColumnCount-1
            row.Put(r.GetColumnName(j), r.GetString2(j))
        Next
        Results.Add(row)
    Loop
    r.Close

Click to expand...