Unable to read from existing SQLite database in Android

I am trying to read data from an existing SQLite database (in the /data/data/myaplication/databases folder). However, when executing an SQL query I keep getting the exception

android.database.CursorIndexOutOfBoundsException: Index 0 requested, with a size of 0

The strange thing is that I can write to the database (without an exception). However, this does not reflect in the database on file.

I am not sure why this is happening and what I am doing wrong. Any help will be appreciated.