CODEWITHSUNDEEP
androidsqliteinsert-updateunique-constraint
Usman Malik
Usman Malik

Reputation: 27

How to update all attributes of a row except Unique Constraint attribute in Android SQLITE?

I am working on an android app. In database I have a column that applied Unique Constraint. CreateEntry Method Working Perfectly.

Now In Create Entry Method I want to update all attributes except Unique Attribute.

My Current Code Goes Here:

Creating Table

public void onCreate(SQLiteDatabase db) {
    db.execSQL("CREATE TABLE " + DATABASE_TABLE1 + " (" + KEY_ROWID
        + " INTEGER PRIMARY KEY AUTOINCREMENT, " + KEY_NOTE
        + " TEXT NULL, " + KEY_NUMBER + " TEXT NOT NULL UNIQUE);");
}

CreateEntry Method In Database Class 

public long createEntry(String number, String note) throws SQLException {
    ContentValues cv = new ContentValues();
    cv.put(KEY_NUMBER, number);
    cv.put(KEY_NOTE, note);

    return callBlockerDatabase.insert(DATABASE_TABLE1, null, cv);
}

as KEY_NUMBER is unique attribute.

First attempt: i passed "123" as number and "abc" as note to CreateEntry Method.

2nd Attempt: I passed "123" as number and "xyz" as note.

In second attempt I want to Update "xyz" as note a in specified row.

Please help me to update CreateEntry Method for achieving mentioned goal ?

Upvotes: 1

Views: 318

Answers (1)

N J
N J

Reputation: 27515

As you specified the KEY_NUMBER to unique it will not accept duplicate value '123'

Upvotes: 1

Related Questions