Populating An Android Sqlite Database

Currently i'm trying to populate a database table created in android. I have created a database adapter which allows my activities to run the methods from this adapter. DBAdapter.

Solution 1:

You are creating the table called assignments but not the table 'expenses'. Amend your DATABASE_CREATE statement.

Solution 2:

In the DDMS view, you can save the database file (button near top right corner), and open it in an SQLite viewing program. This will allow you to check specific tables - http://sourceforge.net/projects/sqlitebrowser/ I took it from your post that you'd checked for the database, but not looked inside at the tables yet?

I think you have do to this with a database created from running on the emulator unless your phone is rooted or something.

You can then check whether your database has all the correct tables and fields. Also you can run your SQL table creation / insertion code before running it in the code and having to guess at the issue.

Only issue is that sometimes it just breaks if the SQL is invalid. It's not going to do you any favours like Navicat, but it'll work if your SQL is correct.