SQLITE Android delete query Executed but not Delete That value. It Shows again on APP launch -


here code

public void deletenote(string tv){      sqlitedatabase db = this.getwritabledatabase();     db.execsql("delete tbt name='" + tv +"'");     db.close(); } 

image:

enter image description here

you should use db.delete

public void deletenote(string tv){         sqlitedatabase db = this.getwritabledatabase();         db.delete(database_table, key_name + "=?", new string[]{tv});     } 

Comments