How can I edit the SQLite database after creating and saving it on my phone with the corresponding application? I want to add a new column to the database, but I cannot figure out how to do this. Is it possible to do this through the adb shell or maybe an eclipse? Or in code?
I tried just updating my db-adapter class, but then the application did not compile time with the following Exception:
android.database.sqlite.SQLiteException: No such columns <column_I_want_to_add>
Simple removal and reinstallation of the application will also not work.
Here's a link to my db adapter class if it has any help. The column I'm trying to add is MILLIS_COLUMN. link pastie.
Linus
source
share