Skip to content

sqlrequest: members

5 implemented, 0 reserved. Entries are sorted by name.

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.

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.

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.