sqlrequest: members
5 implemented, 0 reserved. Entries are sorted by name.
Implemented
Section titled “Implemented”columns
Section titled “columns”sqlrequest.columns: array
Runs on: server only. Origin: engine extension. Since: M12. Playground: no. read-only.
The column names of the result, in order, also when no row matched.
echo(temp.req.columns[0]);Specification: standard-library.md§13.2.
completed
Section titled “completed”sqlrequest.completed: number
Runs on: server only. Origin: compatibility. Since: M12. Playground: no. read-only.
1 once the statement finished, 0 before.
if (temp.req.completed) echo(temp.req.rows.size());Specification: standard-library.md§13.2.
sqlrequest.error: string
Runs on: server only. Origin: compatibility. Since: M12. Playground: no. read-only.
The SQLite error message when the statement failed, else empty. A failed statement raises no script error.
if (temp.req.error != "") echo(temp.req.error);Specification: standard-library.md§13.2.
lastinsertid
Section titled “lastinsertid”sqlrequest.lastinsertid: number
Runs on: server only. Origin: compatibility. Since: M12. Playground: no. read-only.
The row id of the last INSERT the statement made.
echo(temp.req.lastinsertid);Specification: standard-library.md§13.2.
sqlrequest.rows: array
Runs on: server only. Origin: compatibility. Since: M12. Playground: no. read-only.
The result rows, one array per row, when expectResult was true. INTEGER and REAL values are numbers, TEXT values are strings, NULL is empty, and a BLOB is a string of its bytes.
echo(temp.req.rows[0][1]);Specification: standard-library.md§13.2.
Engine version 0.1.0. Built 2026-11-18.