Android SQL Delete row not working

Question

Firstly I am creating a Database in a helper class as follows:

public void onCreate(SQLiteDatabase db) {
    String sql = "create table " + TABLE + "( " + ID
            + " integer primary key autoincrement, " + FIELD1 + " text, "
            + FIELD2 + " text);";
    Log.d("EventsData", "onCreate: " + sql);
    db.execSQL(sql);
}// Where public static final String ID = "_id"; ect.

I have then inserted data and I have seen it works by displaying the inserted data in a TextView. My problems come when I need to delete a row.

I can deleted everything by using

db.delete(TABLE, null , null); (again I can see that this works)

However if I change it to deleted a single row such as

db.delete(TABLE, "_id" + Index, null); Where for example int Index =4;

nothing happens, I get no errors and no delete.

Can anyone help with why this happens?

GuilhE · Accepted Answer · 2015-08-11 00:23:46Z

2

SQLiteDatabase db = this.getWritableDatabase();    
db.delete(TABLE_CONTACT, _ID + "=" + _id, null);
db.close();

edited Aug 11, 2015 at 0:23

GuilhE

11.9k17 gold badges82 silver badges122 bronze badges

answered Aug 10, 2015 at 22:34

Sajidkhan

6187 silver badges16 bronze badges

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

Comments

antlersoft · Accepted Answer · 2011-08-05 20:31:21Z

1

Try

db.delete(TABLE, "_id = ?", new String[] { "" + Index });

answered Aug 5, 2011 at 20:31

antlersoft

14.8k4 gold badges40 silver badges56 bronze badges

Comments

Aplit · Accepted Answer · 2016-08-26 07:33:55Z

0

db.delete(TABLE, "_id=" + Index, null);

answered Aug 26, 2016 at 7:33

Aplit

711 silver badge6 bronze badges

Collectives™ on Stack Overflow

Android SQL Delete row not working

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related