SQL persistance

[wcklr]

A short post from SQL persistance.lua

local sqlite3 = require("lsqlite3")

local db = sqlite3.open(app.dir() .. "/foo.db")

db:exec[[
CREATE TABLE test (id INTEGER PRIMARY KEY AUTOINCREMENT, content);
]]

print(db:errmsg())

db:exec[[
INSERT INTO test (content) VALUES ('corrupt#8513');
]]

print(db:errmsg())

for row in db:nrows("SELECT * FROM test") do
print(row.id, row.content)
end

db:close()

a screenshot

[tomasguisasola]

Hi

I didn't understand what you mean with this issue. What is the problem?