B4J Question KeyValueStore - Resultset not closed?

jmon said:

I have a question regarding KeyValueStore.

Click to expand...

For Each k As String In kvs.ListKeys
        Log(k)  'displays all keys
    Next

Public Sub ListKeys As List
    Dim res As List
    res.Initialize
    res.AddAll(kvs.ListKeys)
'    For Each k As String In res
'        Log(k)
'    Next
    Return res
End Sub

jmon said:

I usually close all my resultsets, but why is "c" not closed here?

Click to expand...

'Returns a list with all the keys.
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

OliverA said:

1) Apologies for the previous answer I posted. I failed reading comprehension on that one.
2) Looking at the old source:

B4X:

'Returns a list with all the keys.
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

The close is there.
Source: https://www.b4x.com/android/forum/t...imple-powerful-local-datastore.63633/#content
So I don't know which version you were using. In the end, the point is mute, since it's been replaced (and you are now attempting to use the new b4xlib version).

Click to expand...

OliverA said:

The close is there.

Click to expand...

Mahares said:

There must be something to it.

Click to expand...