Android Question SQLite vs. B4A SQL Object

Claudio Oliveira

Claudio Oliveira

Active Member
Licensed User
Longtime User
Hi everybody,

SQLite implements the SQL commands "BEGIN TRANSACTION", "COMMIT TRANSACTION", "ROLLBACK TRANSACTION", "END TRANSACTION", "SAVEPOINT", etc...
Are there any recommendations on wich is the best way to manage database transacions?
I mean, which is better: using B4A SQL object methods, or native SQL commands implemented by SQLite itself?
Sometimes it gets a bit confusing to me, as SQL object has no "rollback" method, which leads me to use an SQLite command to rollback a transaction.
Same thing when one needs to create nested transactions, which is quite common on database application development, and as far as I know is supported by SQLite "SAVEPOINT" command, but not by B4A SQL Object...

Thanks and regards!
Claudio
 
Sort by date Sort by votes
Erel

Erel

B4X founder
Staff member
Licensed User
Longtime User
B4A SQL object is based on the native API. Eventually the same SQL commands are executed.

The recommended code is:
B4X: 
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) 'no changes will be made
End Try
SQL1.EndTransaction

If you call EndTransaction without calling TransactionSuccessful then the transaction will be rollbacked.
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Code Snippet Using SQLite
Replies
0
Views
1K
Cadenzo
  • Article
Android Tutorial [B4X] B4XTable - Load data from SQL database
Replies
4
Views
24K
Erel
  • Locked
  • Article
Android Tutorial [B4X] SQL with Wait For
Replies
16
Views
34K
Erel
R
  • Question
Android Question SQLite character encoding vs GetBytes
Replies
5
Views
2K
Palle
  • Locked
  • Article
Android Tutorial SQL tutorial
7 8 9
Replies
161
Views
291K
luciano deri