Android Question SQLite not updating after exit program

[Bernard Harris]

Hello, I have an Android app that I created a year ago. It does updates to a SQLite database installed with the app. It worked fine on Android 10 but with Android 12 when we make changes and then exit the app the changes are not saved. When we restart the app it starts with the data just like it was originally installed. Is there something special that needs to be done to save all changes before exiting the app now?

 

[Erel]

Nothing special is needed. My guess is that the problem is somewhere else.

Are you doing anything with the db file? The database can be made of 3 files. If you for example only copy the main file, the new data will be lost.

 

[Brian Dean]

Where (in which directory location) are you saving the data?

 

[Bernard Harris]

Sorry so late in getting back to your quick response.
I am only copying the .db file. What other files are there to copy along with the .db file?

This is the statement I am using to get the database to the phone:

File.Copy(File.DirAssets, "inventory.db", File.DirInternal, "inventory.db")

 

[Bernard Harris]

With the latest update of the app I also created Indexes in SQLite. Could that be why it's not updating also? And are the indexes stored separately and they have to be copied?

 

[Erel]

Indices are not related.

This is the statement I am using to get the database to the phone:

File.Copy(File.DirAssets, "inventory.db", File.DirInternal, "inventory.db")

Are you checking that the file doesn't exist before copying?
How is the database gets updated?

 

[Bernard Harris]

I believe you hit on my problem Erel. I had the If condition in there to check if it exists and if not then copy the file. I commented this condition out and this must be copying from the install back in and causing it to reset each restart. I will put that back in. It just hit me this morning that this might be the issue! Sorry for the dumb question when it's my own fault. BUT thanks for your help!

Can I ask another question? What is the best method to copy this db back to the installed desktop? I want to retrieve what has been entered here. Thanks again!

 

[Mahares]

What is the best method to copy this db back to the installed desktop?

Normally, you need to post a different question in a different thread, but since this has been answered hundreds of times:
The answer to your question is in this thread:

SaveAs - Let the user select a target folder + list of other related methods

B4A + B4i example: https://www.b4x.com/android/forum/threads/b4x-texteditor-save-and-load-external-files.132731/#post-838166 List of classes or libraries that can be used to access secondary storages: ContentChooser (Phone libray) - allows the user to select a resource or file using external...

www.b4x.com