How to use SQLite3?

[xoft]

The exec method returns an error code, use that to troubleshoot:

1 2 3

local sqlq = "INSERT INTO TestTable(ID,One,Two) VALUES (\'25\',\'35\',\'45\')" local ErrCode, ErrMsg = TestDB:exec(sqlq) LOG("Error code " .. (ErrCode or "<unknown>"))

Then use the table here to decipher: http://lua.sqlite.org/index.cgi/doc/tip/...sult_codes