Hi,
I try to update the text data but it isn’t update
Here is some code:
- require “sqlite3”
- local path = system.pathForFile(“data.db”, system.DocumentsDirectory)
- db = sqlite3.open( path )
- local tablesetup = [[CREATE TABLE IF NOT EXISTS data (id INTEGER PRIMARY KEY autoincrement, text);]]
- db:exec( tablesetup )
- local t = “Old text”
- local q = [[INSERT INTO data VALUES (NULL, ‘]] … t …[[’);]]
- db:exec( q )
- for row in db:nrows(“SELECT * FROM data WHERE id = 1”) do
- print(row.text)
- end
- local t = “New text”
- local Update = [[UPDATE data SET text =]] … t … [[WHERE id = 1]]
- db:exec(Update)
- for row in db:nrows(“SELECT * FROM data WHERE id = 1”) do
- print(row.text)
- end
How can i do?