Android Question SqlLite update not permanent.

[tremara1]

Sub updateIt
'update record
Dim newNum As String = lblScript.Text
Dim strUpdateName As String = sp1.SelectedItem
Dim strMedUpdateName As String = lblmedname.text
    sqlText = "UPDATE data SET script = '" & newNum & "'"
    sqlText = sqlText & " WHERE name = '" & strUpdateName "'"
    sqlText = sqlText & " AND med = '" & strMedUpdateName & "'"
SQL1.BeginTransaction
        SQL1.ExecNonQuery(sqlText)
SQL1.EndTransaction

pnlAdd.Visible = False
pnlEdit.Visible = False
pnlMed.Visible = True
SelectItAll

End Sub

This update seems to work and displays the new info when queried. If I userclose the info seems to be retained when app restarted but when I close the app from recent apps or reboot the updated info is not retained. If I do inserts of new records they are retained.
Only seems to be since android 4.4 update (Sony xperia ultra 2). Any clues...

 

[Mahares]

I think you should commit the update by adding the TransactionSuccessful

SQL1.BeginTransaction
 SQL1.ExecNonQuery(sqlText)
 SQL1.TransactionSuccessful   'add this
 SQL1.EndTransaction

 

[LucaMs]

You could use the example as in the "intellisense":

and don't forget to close the db!

 

[tremara1]

You guys have done it again..........the TransactionSuccessful was what I missed. Thanks.

 

[LucaMs]

Yes, but use the Try-Catch structure... I am afraid that TransactionSuccessful declares the transaction successfully completed.

 

[tremara1]

Will do....thanks.