CODEWITHSUNDEEP
javaandroidandroid-sqlite
Priyanka Prajapati
Priyanka Prajapati

Reputation: 1

In SQLite database insertWithOnConflict is not working in android application

In my sqlite database I used insertWithOnConflict method in application for ignore duplicate data entry in my sqlite database inn android application. But some how I don't know it's not working in my code. If any one have solution regarding this issue so help me.

Here below my code. 

 public void AddPattern(Pattern_Model pattern_model) {
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values = new ContentValues();
    //values.put("id",pattern_model.getId());
    values.put("pattern_name", pattern_model.getPattern_name());
    values.put("value", pattern_model.getPattern_value());

   long ln= db.insertWithOnConflict(TABLE_NAME, "pattern_name",values, SQLiteDatabase.CONFLICT_IGNORE);

    //db.insert(TABLE_NAME, null, values);
    db.close();
    if(ln != -1){
        Log.d("replace", "ok");
    }
}

Upvotes: 0

Views: 1505

Answers (1)

buzzingsilently
buzzingsilently

Reputation: 1586

You need to use CONFLICT_REPLACE for your requirement,

long ln= db.insertWithOnConflict(TABLE_NAME, BaseColumns._ID,values, SQLiteDatabase.CONFLICT_REPLACE);

Upvotes: 1

Related Questions