Hi,
I'm working on an app (Android) with a SQLite database. I use SQLite Expert on my PC to design and modify my SQLlite database, which is stored in the 'Files' folder of my B4A project.
The first time I Compile and Run my app the SQLite database is copied over to my phone and all is good.
If I subsequently modify the SQLite database, i.e. add a table, add some columns, etc... the changed SQLite database is not copied over to my phone when I Compile and Run and obviously the app crashes.
I'm sure I'm missing something simple but my question is:
I'm working on an app (Android) with a SQLite database. I use SQLite Expert on my PC to design and modify my SQLlite database, which is stored in the 'Files' folder of my B4A project.
The first time I Compile and Run my app the SQLite database is copied over to my phone and all is good.
If I subsequently modify the SQLite database, i.e. add a table, add some columns, etc... the changed SQLite database is not copied over to my phone when I Compile and Run and obviously the app crashes.
I'm sure I'm missing something simple but my question is:
Where should I store the SQLite database on my PC when developing the app?
and/or
How do I get the updated SQLite database to move onto the phone when I Compile and Run?
Thanks in advance...and/or
How do I get the updated SQLite database to move onto the phone when I Compile and Run?
