On 8 May 2014, at 10:14am, techi eth <techi...@gmail.com> wrote:

> SQlite3 have any method where it can avoid adding duplicate row or throwing
> error status code on duplication.,

Instead of

INSERT ...

do

INSERT OR IGNORE ...

This means that instead of returning an error code if you violate a constraint, 
SQLite just returns SQLITE_OK as if the command succeeded.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to