Reputation: 21
when I want to delete a row from my table, the toast shows me "error" while the line has been deleted
Supprimer.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
db = dbhelper.getWritableDatabase();
Cursor c = db.rawQuery("DELETE FROM Biblio WHERE nom = \""+user.getText().toString()+"\" AND type= \""+spinner.getSelectedItem().toString()+"\"",null);
if(c.moveToFirst()){
Toast.makeText(getActivity(), "deleted", Toast.LENGTH_LONG).show();
}else{ Toast.makeText(getActivity(),"Erreur",Toast.LENGTH_LONG).show();}
}
});
Upvotes: 0
Views: 85
Reputation: 62851
rawQuery
returns a cursor but delete
returns rows deleted, so the rawQuery
statement is, I think, unusual. I would recommend something like the following:
db.delete ("Biblio", "nom = ? AND type = ?", new String[] {user.getText().toString(), spinner.getSelectedItem().toString()})
You will get an int back that is the number of rows deleted.
Upvotes: 1