How to delete record using SQLiteDatabase?

Question

I need to delete the record from Sqlite, My table name is "TABLE_NAME" and column name
is "COLUMN1", I pass the string value from MyTable.java to mySqliteHelper.java.
I need to delete this record which value I pass. Here is my sample code.
Give me hint or suggestion. Any help is appreciated.

MyTable.java

AlertDialog.Builder alert = new AlertDialog.Builder(this);

    alert.setTitle("Delete Profile");
    alert.setMessage("You want to delete this profile?");       
    alert.setPositiveButton("Ok", new DialogInterface.OnClickListener()
    {
        public void onClick(DialogInterface dialog, int whichButton)
        {         
            MySQLiteHelper m=new MySQLiteHelper(getBaseContext());
            m.deleteBName(other);   
            deleteMessage();
        }
    });

MySQLitHelper.java

public void deleteBName(String keyword) 
{
    try
    {
        SQLiteDatabase db=this.getWritableDatabase();
        db.delete(TABLE_NAME, COLUMN1+"="+keyword, null);   
    }
    catch(Exception e)
    {
        e.printStackTrace();
    }

}

Rahul garg · Accepted Answer · 2012-03-11 06:08:23Z

1

use something like this

db.delete(TABLE_NAME, "column_name=?", new String[]{String.valueOf(keyword)});

Refer to documentation here

answered Mar 11, 2012 at 6:08

Rahul garg

9,3925 gold badges37 silver badges67 bronze badges

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

2 Comments

Rahul garg Over a year ago

db.delete() return the rows affected..so for debugging , do int temp = db.delete(...); and check if the rows are getting affected or not,, otherwise it might be minor problem with spelling or something.... btw the second parameter must be as it is, like COLUMN1+"=?" no reference to keyword here...

Sandip Armal Patil Over a year ago

Hey thanks! it's working.actually i enter wrong column name....Thank you very much...

TLama · Accepted Answer · 2014-12-27 10:31:58Z

0

Try this code:

dbHelper.delete(DATABASE_TABLE_2, KEY_NAME + "=?", new String[] { myName })

edited Dec 27, 2014 at 10:31

TLama

76.9k17 gold badges226 silver badges418 bronze badges

answered Oct 22, 2012 at 13:13

Durgpal Singh

12k4 gold badges40 silver badges50 bronze badges

Collectives™ on Stack Overflow

How to delete record using SQLiteDatabase?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related