Android SQLite delete multiple rows

Question

I want to delete all rows in a table with a specific ID (not primary key). I have tested two different methods, but they only remove the first row it finds with the specific ID:

db.delete(CalendarTable.TABLE_NAME, "repeat_group="+repeatGroup, null);

and

db.delete(CalendarTable.TABLE_NAME, "repeat_group=?", new String[]{Integer.toString(repeatGroup)});

None of these methods works, how can I remove ALL rows in a table with this specific ID? Thanks in advance!

UPDATE: Lol, the method above did work! It was just me the stupid one that called the my own method delete() instead of deleteRepeatGroup(), guess I'm too tired! Anyways, thank you guys for taking your time.

I dont think I'm using transaction, how can I be sure if I do? — Carnal
– Carnal, Commented Oct 11, 2011 at 13:08
I even tried: db.rawQuery("DELETE FROM calendar WHERE repeat_group="+repeatGroup, null); — Carnal
– Carnal, Commented Oct 11, 2011 at 13:18
It has nothing do with transaction. The solution can be you can a raw query as the first answer suggest. — Rocker
– Rocker, Commented Oct 11, 2011 at 13:19
I've tried a raw query too. Doesn't work, only deletes the first row =/ — Carnal
– Carnal, Commented Oct 11, 2011 at 13:21

banzai86 · Accepted Answer · 2011-10-11 13:18:16Z

1

If everything else fails, you can try the following. Get all rows in the table with the ID you are trying to delete and save the rowID's in an array. Then iterate over the array and delete each row.

I hope this works as expected

answered Oct 11, 2011 at 13:18

banzai86

7471 gold badge5 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hanry · Accepted Answer · 2011-10-11 12:57:55Z

1

you can use

String urQuery = "delete from tablename where Id in ("
    + Id + ")";

here Id may have all ids separated by comma ex. "id1,id2".

answered Oct 11, 2011 at 12:57

Hanry

5,5412 gold badges43 silver badges56 bronze badges

Collectives™ on Stack Overflow

Android SQLite delete multiple rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related