error code 19: constraint failed

[Sherif Shehab]

Hi,
i'm trying to insert some data in the Android sqlite it was inserted successfully but this error occurs :

05-23 00:26:27.973: ERROR/UpdaterService(1998): android.database.sqlite.SQLiteConstraintException: error code 19: constraint failed
05-23 00:26:27.973: ERROR/UpdaterService(1998):     at android.database.sqlite.SQLiteStatement.native_execute(Native Method)
05-23 00:26:27.973: ERROR/UpdaterService(1998):     at android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java:61)
05-23 00:26:27.973: ERROR/UpdaterService(1998):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1582)
05-23 00:26:27.973: ERROR/UpdaterService(1998):     at android.database.sqlite.SQLiteDatabase.insertOrThrow(SQLiteDatabase.java:1452)

i cant understand what is for !! any clues ?

[Peter Johnson]

When you create a database, you can specify that values in certain columns must meet certain conditions. If those conditions are not met, then you get a constraint violation error. Often this means that two records have the same key value (unique key values are often implied constraints). Check the data you are inserted to see of two records have the same key.

[Sherif Shehab]

Thanks Peter for clarification ....