I’ve come quite far with my sqlite but I for the moment I can’t figure out how to concatenate my UPDATE, can anyone make me a little wiser…?
I created my db.
local setup = [[CREATE TABLE IF NOT EXISTS countData (id INTEGER PRIMARY KEY autoincrement, tapCount INTEGER );]]
db:exec(setup)
local insert = [[INSERT INTO countData VALUES(NULL, 0)]]
db:exec(insert) Then in my tapListener I retrieve the tapCount value and add one for each tap
I want to concatenate ‘value’ and update the count
local value = tapCount+1
local update = [[UPDATE countData SET tapCount = 'value' WHERE id=1]]
db:exec(update) I get it to update the value in my print but not in the db, how do I concatenate the ‘value’ in my update? [import]uid: 65840 topic_id: 35499 reply_id: 335499[/import]