[sqlite] create or update question

[Eric S. Johansson]

I'm trying to figure out how to do do the following:

if the record exists
  Update record with calculation ( a = a + v)
else
  insert record with default values
It seems like the "insert or replace into" capabilities is close to what 
I need but I can't figure out how to update with a default on the first 
record and update with a calculation on existing records.

Seems like this should be a very common idiom but I can't find any notes 
on how to do it.

--- eric

--
Speech-recognition in use.  It makes mistakes, I correct some.

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------