+- Cuberite Forum (https://forum.cuberite.org)
+-- Forum: Plugins (https://forum.cuberite.org/forum-1.html)
+--- Forum: Plugin Discussion (https://forum.cuberite.org/forum-8.html)
+--- Thread: How to use SQLite3? (/thread-1917.html)
Pages:
1
2
RE: How to use SQLite3? - xoft - 06-02-2015
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/doc/lsqlite3.wiki#numerical_error_and_result_codes