I have a firemonkey multi device project for iOS and Android. I use a SQLite database to store my data. I deploy the database through adding the file in project deployment and setting the remote path.
Right now if I make any changed to my database and then update my app the old database stays. Only if delete the app and reinstall it i get the new database or if i delete the app data i get the new database.
But I want to update the database with new tables/colomns/inserts without losing any data inside the old database.
How do i do this?
I've made a class that checks the current version of the database and the last version. If it's not up to date it will run the update queries runtime.