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?
In the basic Android tutorials that Google provides, the section on putting information into a database using the insert() function involves using a column called COLUMN_NAME_NULLABLE which had not been listed before in describing the schema or database itself via SQLiteOpenDbHelper, so I had assumed that it was generated automatically by implementation of BaseColumns, similary to the _ID column.
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).
In my android application i'm using a manually created sqlite database.It works fine.Now i want to create a another temporary sqlite database by the application not manually.For that i created another Database helper class.Following is the code.But that databse is not creating.I checked the DDMS file explorer to verify the database.But it shows only my manually created database.