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 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.