I have an SQLite database which I created by using DB Browser, I putted it in assets file and I use SQLiteAssetHelper to access it. Why if I update any record using DB Browser It dose not change in my app ?!
Also If I execute insert query in my app, the new record does not appear in DB Browser.
You're dealing with 3 different databases:
The database you create with DB Browser and is stored in a folder in your pc.
The database in assets
folder which is a copy of the database you created with DB Browser
The database in your emulator/device that was created the 1st time you ran the app.
This last database originally was a copy of the database you had in assets
folder.
When you make changes to the database in case 1, these changes are not reflected to either the database in assets
folder or in your emulator/device.
If you want these changes to be made to your emulator/device database, you must:
assets
and copy there the changed DB Browser database.When you make changes to the emulator/device and you want to examine the database with DB Browser: