Fatal - RuntimeException SQLite Remove Data from Database

Question

I am trying to delete data from SQLite table where source column equals to "Online"

java.lang.RuntimeException: Unable to start activity ComponentInfo{com.reminders/com.reminders.FetchDataActivity}: android.database.sqlite.SQLiteException: no such column: Online (code 1): , while compiling: delete from ReminderTable where source = Online

Here is my code:

public void deleteOnlineReminders() {
        SQLiteDatabase db = this.getReadableDatabase();
        db.execSQL("delete from "+ TABLE_REMINDERS + " where " + KEY_SOURCE + " = " + "Online");
    }

Or Is it due to reason that I don't have any data into table where column source = Online

Answer 1

You have to use 'Online' in your string concat (note the quotes).

As you can see from the exception, the compiled statement is otherwise wrong as you are refering to a column, not a string.

You may also want to use prepared statements instead of string concatenation for your parameter: How do I use prepared statements in SQlite in Android?

This is the more clean and safe version :)

Answer 2

Try this code.

db.execSQL("delete from "+ TABLE_REMINDERS + " where " + KEY_SOURCE + "=?",new String[] { "Online" });

Answer 3

public void deleteOnlineReminders() {
    SQLiteDatabase db = this.getWritableDatabase();       
    dbHelper.delete(TABLE_REMINDERS, KEY_SOURCE + "=?", new String[] { Online})
}