Sqlite & flex - insert into if not exists?

Insert duplicate data with the same primary key and use a "IGNORE" conflict clause: sqlite> create table t(i integer primary key not null); sqlite> insert into t values(1); sqlite> insert or ignore into t values(1); sqlite> select * from t; 1 Duplicate values will not be inserted, and the statement will complete successfully Alternatively, you can use "UNIQUE" constraint instead of a primary key: sqlite> create table t(i integer unique not null); sqlite> insert into t values(1); sqlite> insert or ignore into t values(1); sqlite> select * from t; 1 The idea is that some constraint will get violated and the row will be ignored.

Insert duplicate data with the same primary key and use a "IGNORE" conflict clause: sqlite> create table t(i integer primary key not null); sqlite> insert into t values(1); sqlite> insert or ignore into t values(1); sqlite> select * from t; 1 Duplicate values will not be inserted, and the statement will complete successfully. Alternatively, you can use "UNIQUE" constraint instead of a primary key: sqlite> create table t(i integer unique not null); sqlite> insert into t values(1); sqlite> insert or ignore into t values(1); sqlite> select * from t; 1 The idea is that some constraint will get violated and the row will be ignored.

Thanks for the insight but I'm still not having any luck... – Adam Feb 4 '10 at 23:35.

Thanks for the insight but I'm still not having any luck. Here's my code stmt. Text = "CREATE TABLE IF NOT EXISTS tbl_breed ("+" breed_id INTEGER PRIMARY KEY AUTOINCREMENT, "+" breed_breed TEXT)"; stmt.execute(); stmt.

Text = "INSERT OR IGNORE INTO tbl_breed (breed_breed)"+" VALUES ('Test')"; stmt.execute(); Ok so I fixed the problem - I guess you have to hard code primary key here's what I did stmt. Text = "CREATE TABLE IF NOT EXISTS tbl_breed ("+" breed_id INTEGER PRIMARY KEY AUTOINCREMENT, "+" breed_breed TEXT)"; stmt.execute(); stmt. Text = "INSERT OR IGNORE INTO tbl_breed (breed_id,breed_breed)"+" VALUES ('1','test')"; stmt.execute().

First, Stackoverflow format is a little different from forums, you should really edit your question and include this code in it. As for the code itself, you are creating a new primary key every time, you should insert the duplicate explicitly, so the constraint gets violated and the row is ignored. – Alex B Feb 5 '10 at 0:17 See updated answer.

And don't forget to edit your quesiton. :) – Alex B Feb 5 '10 at 0:19.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.