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?