stmt:first_row()

Execute a prepared statement using the currently assigned bind variables and return the first row of data as a table using the column names as the index.

Example

db=sqlite.open('testdb')
stmt,err=db:prepare[[
select max(x) max_x, min(x) min_x
from foo
where x between ? and ?
]]
stmt:bind(1,100)
row = stmt:first_row()
max, min = row.max_x, row.min_x