My native app uses the cordova-sqlite-evcore-extbuild-free plugin.
I have Database.db,DB,loadGrid,NSB.overwriteAlways in extraFiles.
The app and the database work fine together; while the app is running CRUD works as expected.
When I close the app, the database changes are not saved. What have I missed?
Given that a user might close an app at any time, what if anything needs to be done after every SQL transaction to ensure that data is saved?
8.5.1.2b2
iOS 12… and Android 10
Yes, it’s defined and as I mentioned, the SQL statements read/write to the database and update the jqxGrid as they should.
The app works as it should. Do I need to close the database after each transaction?
Should the database persist when it runs in the AppStudio browser?
As is often the case, the answer is simple…once you find it…
Database.db,DB,loadGrid,NSB.overwriteNever - This only overwrites the DB if it doesn’t exist.
Once the app has “saved” the data in the database, you can quit the app and the data is in the database when you restart the app. No need to close the database.
This is true for native apps and when the app runs on the AppStudio browser.