Re: [sqlite] read and update record at the same time

[Hugh Gibson]

You might find the syntax "INSERT OR REPLACE INTO" useful. It will do an 
UPDATE if the record exists, or INSERT if it doesn't exist.

See http://www.sqlite.org/lang_insert.html

Hugh