B4J Question SQLite and resultset

[rodmcm]

In B4a I use ResultSet to capture a database Table, I then eliminate the information in the Table, reconfigure and store it in the same Table, with alterations using the data in the ResultSet.

Works fine.

    rsSorted = Starter.SQL.ExecQuery(Query)
    SQLGeneral.DeleteDataSQLTable(Starter.SQL,"SORTEDTERMS")                    ' Deletes the old data

'Generalised sub to Delete all items from Table
'Does not delete the Table
Sub DeleteDataSQLTable(SQL As SQL,DBname As Object)
    'Log("Delete data from SQLDB")
    Dim Query As String = "DELETE FROM " & DBname
    SQL.ExecNonQuery(Query)
End Sub

If I try this with B4j then rsSorted has no data at all after the delete of the database

Why would this be so?

 

[LucaMs]

Perhaps you are checking the db in the assets, after executing the query (your routine).
Check the db path.

 

[Erel]

You can use DBUtils.ExecuteMemoryTable to read the complete data into a list. It will then be kept after the data is deleted.