Android Question RollbackTransaction

[b4auser1]

I didn't find RollbackTransaction method in SQL library, only TransactionSuccessful for commit

Public Sub Commit ()
    m_dbSQL.TransactionSuccessful
    m_dbSQL.EndTransaction
End Sub

Could I use the code shown below ?

Public Sub Rollback ()
    m_dbSQL.ExecQuery("ROLLBACK")
    m_dbSQL.EndTransaction
End Sub

 

[Mahares]

Try something like this:

 'Below will not commit, but rolls back
    SQL1.BeginTransaction
    txt="DELETE FROM MyTable WHERE product = 'orange'"
    SQL1.ExecNonQuery(txt)
    txt="ROLLBACK"
    SQL1.ExecNonQuery(txt)

 'Below will commit and deletes
    SQL1.BeginTransaction
    txt="DELETE FROM MyTable WHERE product = 'orange'"
    SQL1.ExecNonQuery(txt)
    'txt="ROLLBACK"
    'SQL1.ExecNonQuery(txt)
     SQL1.TransactionSuccessful
     SQL1.EndTransaction

 

[Erel]

@Mahares is correct. However there should be a SQL1.EndTransaction in the first example.

EndTransaction without TransactionSuccessful = Roll back.