How to delete some rows from database using delete function in Android?

Question

I have one table:

    CREATE TABLE People 
    (
       id INTEGER PRIMARY KEY AUTOINCREMENT, 
       name
    );

I wanted to delete some rows from the table by using its id as condition. So I tried to use this one but it was not working at all. So have a look:

    //idd is int
    SQLiteDatabase.delete
  (
    "People", 
    "id" + " = ?", 
    new String[]{String.valueOf(idd)}
  );

I dont know why it not working. It may because the String and int datatype. I figure it out something and it may work. But it use only two parameters instead of three. And I want to use three instead. So below is what I have figured out:

        SQLiteDatabase.delete
      (
        "People", 
        "id" + " = ?" + idd, 
       null
      );

So does anyone have any idea and help me out of this problem? I want to delete some rows from my table by using id as whereClause(second parameter) and idd variable which is integer as whereArg(3rd param) with delete function from SQLiteDatabase class.

Rahul · Accepted Answer · 2016-08-07 17:01:27Z

1

SQLiteDatabase.delete("People", "id = " + idd, null);

answered Aug 7, 2016 at 17:01

Rahul

1,4221 gold badge11 silver badges24 bronze badges

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

Comments

Jitin Jassal · Accepted Answer · 2016-08-07 17:15:57Z

0

Try this code

public boolean deleteTitle(Integer idd) 

{

    return db.delete(DATABASE_TABLE, id + "=" + idd, null) > 0;
}

edited Aug 7, 2016 at 17:15

answered Aug 7, 2016 at 17:02

Jitin Jassal

1273 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to delete some rows from database using delete function in Android?

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