Insert only if id doesn't exist

Alright, so we have a phonegap app with a table setup like `tblTest (actualid INTEGER PRIMARY KEY, id INTEGER, name TEXT)` The actualid is a unique id for the device and the id is maintained in a server side database. We've had issues with webservices returning duplicate records and while we're fixing that I wanted to add something to our sql that would prevent duplicates from being added (fixing bad data is a pain). Our current insert statement is setup like `INSERT INTO tblTest (id, name) VALUES (101, 'Bob')` If you run that twice the database will end up looking like ``` actualid | id| name 1 | 101| Bob 2 | 101| Bob ``` And what I'd like for it to look like is ``` actualid | id| name 1 | 101| Bob ``` Insert or Replace would give me an `actualid 2` in the example and any example I've found using a where clause was setup like `INSERT INTO tblTest SELECT ..... WHERE.....` Which doesn't work because none of the data is in a table yet (unless I'm making a newbie mistake, I'm not very good at sqlite or general sql).