You have to call close function on your database after updation/deletion to commit the changes.

db.close()

i have been working on this app which uses sqlite, and i want to update and delete rows when the function is called, the primary key is passed as a parameter in the function. But when the function is called no updates are seen in the table. I am unable to identify where I am going wrong and whats the error, please help.

//create table

 @Override
    public void onCreate(SQLiteDatabase sqLiteDatabase) {
    sqLiteDatabase.execSQL("CREATE TABLE registerJob (JID INTEGER PRIMARY KEY AUTOINCREMENT, JobProfile VARCHAR, Organisation VARCHAR, Location VARCHAR, AboutOrg VARCHAR, AboutJob VARCHAR, Incentives VARCHAR , Salary INTERGER, Number INTEGER, Category Varchar, Duration number,Twitter Varchar, Facebook Varchar, LinkedIn Varchar)");
}

//update vacancy
    public void updateVacancy(String orgName,String aboutOrg, String jp, String l, String aoj, int s, String i, int n, int jid) {
        try {
            SQLiteDatabase db = this.getWritableDatabase();
            ContentValues contentValues = new ContentValues();
            contentValues.put("JobProfile", jp);
            contentValues.put("Organisation", orgName);
            contentValues.put("Location", l);
            contentValues.put("AboutOrg", aboutOrg);
            contentValues.put("AboutJob", aoj);
            contentValues.put("Incentives", i);
            contentValues.put("Salary", s);
            contentValues.put("Number", n);
            db.update("registerJob",contentValues," JID= "+jid,null);
            Toast.makeText(contexto, "Data updated", Toast.LENGTH_SHORT).show();
        }
        catch (Exception e)
        {
            Toast.makeText(contexto, "DATABASE HELPER: Update vacancy "+e, Toast.LENGTH_SHORT).show();

        }
    }

    //delete vacancy
    public void deleteJob(int jid) {
        try{
            SQLiteDatabase db = this.getWritableDatabase();
            db.delete("registerJob"," JID= "+jid,null);

        }catch (Exception e){
            Toast.makeText(contexto,"DATABASE HELPER deleteJob "+e,Toast.LENGTH_SHORT).show();

        }
    }