How to delete rows in SQL in android?

See more:

SQL

Mobile

Android

database

I have a notepad application that when you long click on a note in a list activity it will create a dialog that will ask you if you want to delete the note, and when you click yes it will delete the note. But for some reason this doesn't work and it is not becuase the listview does not refresh.

LongItemClick Listener:

@Override
public boolean onItemLongClick(AdapterView<?> av, View v, int position, long id) {
    AlertDialog.Builder alertDialog = new AlertDialog.Builder(this);
    alertDialog.setTitle("Delete...");
    alertDialog.setMessage("Are you sure you want to delete this note?");
    alertDialog.setCancelable(false);

    final int p = position;

    alertDialog.setPositiveButton("Yes", new DialogInterface.OnClickListener() {

        @Override
        public void onClick(DialogInterface dialog, int which) {
            helper.delete(p);
        }
    });

    alertDialog.setNegativeButton("No", null);
    alertDialog.show();

    return true;
}

Delete row method:

public void delete(int id) {
    getWritableDatabase().delete("notes", "_ID="+Integer.toString(id), null);
}