Android SQLite catch error using execSQL

Question

I have a method that runs a INSERT SQL statment that are got from external soruces and not from the android device. The incoming statments can cause duplicate records and I want the android device to ignore the sql statments if they cause duplicates. The method is:

    ourDatabase.execSQL(sql)

The table its inserting the data into has the following column that prevents duplicates

    KEY_CONCATA + " TEXT PRIMARY KEY , " +

Should this be unique and not primary key?

The system at the moment recognizes its causing a duplicate and ends the program, I want it to catch the error and stop it being inserted into the database if its a duplicate.

Thanks!

You can have a TEXT PRIMARY KEY and a primary key is unique by default... What is the error? — Sam
– Sam, Commented Apr 11, 2013 at 18:52

Hoan Nguyen · Accepted Answer · 2013-04-11 18:54:07Z

1

Declare KEY_CONCATA TEXT NOT NULL UNIQUE and when insert use insertWithOnConflict with SQLiteDatabase.CONFLICT_IGNORE flag

answered Apr 11, 2013 at 18:54

Hoan Nguyen

18.2k3 gold badges52 silver badges56 bronze badges

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

5 Comments

user1876202 Over a year ago

Im not sure if this will work, because the incoming is a SQL statment e.g INSERT INTO database_table WHERE..... im guessing such a input would not work with insertWithOnConflict?

Hoan Nguyen Over a year ago

Try KEY_CONCATA TEXT NOT NULL UNIQUE ON CONFLICT IGNORE

Sam Over a year ago

Or KEY_CONCATA + " TEXT PRIMARY KEY ON CONFLICT IGNORE, " +

Hoan Nguyen Over a year ago

@Sam I think your statement requires NOT NULL because sqlite allows PRIMARY_KEY field to be null

user1876202 Over a year ago

KEY_CONCATA + " TEXT NOT NULL UNIQUE ON CONFLICT IGNORE , " + is what worked fo rme

Collectives™ on Stack Overflow

Android SQLite catch error using execSQL

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related