local function do_query(sql) local r local b local vm = db:prepare(sql) assert(vm, db:errmsg()) b=('====================================') b=b..(vm:get_unames()) b=b..('------------------------------------') r = vm:step() while (r == sqlite3.ROW) do --b=b..(vm:get_uvalues()) r = vm:step() end assert(r == sqlite3.DONE) assert(vm:finalize() == sqlite3.OK) b=b..('====================================') Dialog.Message('',b) end local sqlite3 = require("lsqlite3") db = sqlite3.open('test.db') do_query("insert into t values ('aaa')") do_query("select * from t")