Is format String[] whereArgs correct in SQLiteDatabase.delete?

Question

Why this code:

String[] ids = {"5", "1", "3"};
db.delete(ACCOUNTS_TABLE, KEY_ROWID, ids);

return this exception?

android.database.sqlite.SQLiteBindOrColumnIndexOutOfRangeException: bind or column index out of range: handle 0x2069a88

Possible duplicate see http://stackoverflow.com/questions/3314176/delete-row-in-database-table-given-one-column-value-which-is-a-string — Tony Hopkinson, May 08 '12 at 10:13

score 2 · Answer 1 · answered May 08 '12 at 10:16

2

try this:

dbHelper.delete(ACCOUNT_TABLE, KEY_ROWID + "=?", ids);

answered May 08 '12 at 10:16

mihail

score 0 · Answer 2 · answered May 08 '12 at 10:20

0

try to delete single row.

String[] ids = {"5", "1", "3"};
for(int i=0; i<ids.length; i++)
{
    db.delete(ACCOUNTS_TABLE, ids[i], null);
}

Hope this Helps.

answered May 08 '12 at 10:20

Bhavin

2 Answers2