[Solved] logical error in SQLite databse, unable to find such column [closed]

by 


SQLiteException: no such column: _idmoneyreasonDAte: 
[...] while compiling: SELECT _idmoneyreasonDAte FROM MONEY_TABLE

You are selecting all values of a column (called _idmoneyreasonDAte) that doesn’t exist in the table MONEY_TABLE.

The bug is here:

public String getData() {
    // TODO Auto-generated method stub
    String[] columns= new String[]{ KEY_ID  + KEY_MONEY + KEY_REASON + KEY_DATE  };
    Cursor c= ourDatabase.query(DATABASE_TABLE, columns, null, null, null, null, null);

You are concatenating KEY_ID + KEY_MONEY + KEY_REASON + KEY_DATE, which actually gives "_idmoneyreasonDAte".

Funny, I like it.

solved logical error in SQLite databse, unable to find such column [closed]