Android Question How do I commit changes to sqlite?

Wien.Mart

Member
Licensed User
Longtime User
Dear All,

I have a sqlite database being updated by my app. When I update a record set, I do not get the updated values in the table. When I select the specific record set from the table into a form, the updated record is correct. Is there a way to call a specific command to commit the changes to the sqlite so when I load the table again, I get the updated record?

Thanks,

Martin
 
Sort by date Sort by votes

eps

Expert
Licensed User
Longtime User
Martin,

Are you able to show us some of the code? Are you sure you're attempting to retrieve the data you think has changed?

As Erel mentioned, something like :

B4X: 
    SQL1.BeginTransaction

some SQL, update

    SQL1.EndTransaction

some more SQL, read

Should see changes here, but you might want to put a try and catch in, to see if any errors occurred - maybe the SQL update isn't working as expected, so values aren't being updated or the SQL retrieve failed for some reason.


Phil
 
Last edited:
Upvote 0

Claudio Oliveira

Active Member
Licensed User
Longtime User
SQLite also 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, or native SQL commands implemented by SQLite itself?

Regards,
Claudio
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Code Snippet Using SQLite
Replies
0
Views
2K
Cadenzo
  • Question
Android Question sqlite UPDATE
Replies
5
Views
2K
JonnyCav
  • Article
B4A Library [B4X] PreoptimizedCLV - Lazy loading extension for xCustomListView
2 3
Replies
53
Views
40K
Erel
  • Article
B4A Library EasyAR (Augmented Reality) Library UPDATED!
2 3 4
Replies
69
Views
38K
walterf25
K
  • Question
Android Question Jrdc with ucanaccess not committing inserts (Solved)
2 3
Replies
45
Views
13K
Ryan Pigeon
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…