I think I have created an sqllite database with android but every time I go to do an insert it claims a column does not exist. How can I view the schema and is the onCreate method called on object creation?
I created an application for rails. Initially it is running well. Now i am trying to add an extra column to the database. In the database the additional column is not getting updated however I try. I used the onUpgrade() method and altered table but it didnt work.
I am writing an android app. I need to make an SQLite database and populate it when at its creation. So I am trying to populate it in it's onCreate() function. However, to insert data in the database, one needs to use db.getWritableDatabase(). But one can't do this inside the onCreate() function of the database, as that would mean calling the database during it's creation( it throws an error).
I am trying to open file from the pre-build database. The database is around 40-50 MB. I already write the code to copy the database from the asset into the external file. But the database cannot be load.