SQLite Forum

adding record if it doesn't already exist
Login
Why ever would you care?  

If the record did not exist before the insert, then it was inserted; and if it already existed before the insert, then it was not inserted -- the net result in any case, where no error is raised to the application when the statement is executed, is that after execution the record will exist.

What ever else could you possibly need and for what conceivable reason?