CODEWITHSUNDEEP
androidsqlite
Abbes
Abbes

Reputation: 21

delete row from table

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

Answers (1)

Cheticamp
Cheticamp

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

Related Questions