SQLiteException: no such column

Total Post:46

Points:324
 1988  View(s)
Ratings:
Rate this:

I have the below method that when executed gives the error:

11-09 12:11:17.578: E/AndroidRuntime(21018): Caused by: android.database.sqlite.SQLiteException: no such column: happy (code 1): , while compiling: select * from Bank where english = happy

The method is:

public boolean BankHas(Word currentWord) {
        openDataBase();
        Cursor cursor = myDataBase.rawQuery("select * from Bank where english = " + currentWord.english, null);
        return cursor.moveToFirst();
    }

My table scheme:

CREATE TABLE `Bank` (
    `english`   TEXT
);

  1. Post:28

    Points:196
    Re: SQLiteException: no such column

    you missed single quote,so change

    "select * from Bank where english = " + currentWord.english
    to
    "select * from Bank where english ='" + currentWord.english + "'"

    Or recommended solution is to use parameterized query as

    Cursor cursor = myDataBase.rawQuery("select * from Bank where english =? ", new String [] {currentWord.english});

    And change your create table from

    CREATE TABLE `Bank` (
        `english`   TEXT
    );

    to

    CREATE TABLE Bank (
        english TEXT
    );

      Modified On Apr-06-2018 06:24:39 AM

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!