'Below will not commit, but rolls back
SQL1.BeginTransaction
txt="DELETE FROM MyTable WHERE product = 'orange'"
SQL1.ExecNonQuery(txt)
txt="ROLLBACK"
SQL1.ExecNonQuery(txt)
B4X:
'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