Thanks SImon. Pretty much what I expected, just checking if I was missing something obvious. Pete lcSQL Software <http://www.lcsql.com>
On Sun, Dec 16, 2012 at 9:00 AM, <sqlite-users-requ...@sqlite.org> wrote: > I think you 'should not use'. You can do an UPDATE and see whether it > updated anything using the sqlite3_changes() API call or the changes() SQL > function. Then you can decide whether you want to do the INSERT. > > Or you can do a SELECT to find out if there're any existing rows before > you do your INSERT. > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
