### Use Transaction Handling

Use transactions when the set of database operations are atomic.
That is - the operations need to succeed or fail. Nothing in between.
Transactions are to be used to ensure that the database is always in a consistent state.
Framework
Private SQL1 As SQL
SQL1.BeginTransaction
Try
'block of statements like:
For i = 1 to 1000
SQL1.ExecNonQuery("INSERT INTO table1 VALUES(...)")
Next
SQL1.TransactionSuccessful
Catch
Log(LastException.Message)
SQL1.RollBack 'no changes will be made
End Try

Changed: , Category: SQLite, File: T6C254M1833.htm, ID: 1833