android.database.sqlite.SQLiteConstraintException exception in my query

Question

This my query it inserts properly but shows exception

sampleDB.execSQL("INSERT INTO requiredfiles (id, scheduleid, layoutid, status, name, priority,size,checksum) VALUES ('"+ media_id+ "', '"+ scheduleid+ "', '"+ layoutid+ "', '0', '" + url + "', '" + priority + "', '" + size + "', '" + checksum + "');");

android.database.sqlite.SQLiteConstraintException: error code 19: constraint failed -- this is my error -- thanks for ur replay — Neelaganda Moorthy
– Neelaganda Moorthy, Commented Aug 7, 2013 at 9:34
Could you also the creation script of your table and the values you try to enter? — C.Champagne
– C.Champagne, Commented Aug 7, 2013 at 11:10
Yep but the table exists. What's its structure. Are the non nullable fields? — C.Champagne
– C.Champagne, Commented Aug 8, 2013 at 8:04

C.Champagne · Accepted Answer · 2013-08-08 10:34:05Z

1

Well, I already write this despite the lack of information. This error means that a constraint has been violated. It is possible possible that you are inserting a null value into a field that cannot be null or that you intent to set a value to an auto incremental field.

Without knowing anything about the table and the value of the variables, it is impossible to answer more precisely to the question.

Here you can find some tips on how to fix this.

answered Aug 8, 2013 at 10:34

C.Champagne

5,5492 gold badges25 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

android.database.sqlite.SQLiteConstraintException exception in my query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related