Hello, This is the schema: ROWID INTEGER, myText TEXT, numTouched INTEGER
Each time I update a record I'd like to increment its 'numTouched' column. I could read the record, retrieve the numTouched value, increment it by 1, then update the record with the new text and touched values.
Is there a way to do that without SELECT(ing) first the record? Thanks, -- Tito