How to use SQLite3?

[xoft]

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

    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