T Tony Tetley Active Member Licensed User Longtime User Oct 8, 2015 #1 When I do an app update I will have a .CSV file in the DirAssets that will contain some SQLite updates that I want to apply only once. Since you cannot delete a file from DirAssets, how do you determine that this is the first execution after an update install (not a new install) and only apply this file one time? Thanks.
When I do an app update I will have a .CSV file in the DirAssets that will contain some SQLite updates that I want to apply only once. Since you cannot delete a file from DirAssets, how do you determine that this is the first execution after an update install (not a new install) and only apply this file one time? Thanks.
MaFu Well-Known Member Licensed User Longtime User Oct 8, 2015 #2 For this case i have a table "config" in all my sqlite databases with one single record. One field of this record is the version number of the database. With the current database version number i can decide which updates are needed. After each update i increase the version number (simple integer) by one. Upvote 0
For this case i have a table "config" in all my sqlite databases with one single record. One field of this record is the version number of the database. With the current database version number i can decide which updates are needed. After each update i increase the version number (simple integer) by one.
T Tony Tetley Active Member Licensed User Longtime User Oct 8, 2015 #3 Makes sense. Thank you for the reply. Upvote 0