stmt:first_irow()

Execute a prepared statement using the currently assigned bind variables and return the first row of data as an integer indexed table.

Example

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