Deleting Row in SQLite in Android
You can try like this:
//---deletes a particular title---public boolean deleteTitle(String name) { return db.delete(DATABASE_TABLE, KEY_NAME + "=" + name, null) > 0;}or
public boolean deleteTitle(String name) { return db.delete(DATABASE_TABLE, KEY_NAME + "=?", new String[]{name}) > 0;}
Try like that may you get your solution
String table = "beaconTable";String whereClause = "_id=?";String[] whereArgs = new String[] { String.valueOf(row) };db.delete(table, whereClause, whereArgs);
it's better to use whereargs too;
db.delete("tablename","id=? and name=?",new String[]{"1","jack"});this is like useing this command:
delete from tablename where id='1' and name ='jack'and using delete function in such way is good because it removes sql injections.