title: No Such Column Error In Android SQLite
body: <p>I created database. But it gives me "no such column error". I'm sure that my database have that coloumn because i used SQLite Manager to add data. I don't understand why i am getting such error. I've searched this question here, but the answers never helped me. </p>
  
  <p>Most of answers says that If there is no space between column name while writing this code, it gives this error. But i think i writed correctly.</p>
  
  <pre><code>public void onCreate(SQLiteDatabase sqLiteDatabase) {
      sqLiteDatabase.execSQL(
              "CREATE TABLE " + TABLE_NAME + " ("
             + BNUM_COL + " TEXT, " 
            + PNAME_COL + " TEXT, " 
            + AUTHOR_COL + " TEXT, " 
             + TYPE_COL + " TEXT, " 
             + PYEAR_COL + "INTEGER );");
    }
  </code></pre>
  
  <p>My Logcat also showed me :</p>
  
  <pre><code>Cursor c = db.query("btable", SELECT, null, null, null, null, null, null);
  </code></pre>
  
  <p>Please help me.</p>