|Lua SQLite (database) interface
LuaSQLite 3 is a thin wrapper around the public domain SQLite3 database engine.
Open the database with either sqlite3.open or sqlite3.open_memory
Execute "action" SQL statements with db:exec
To query data from the database:
Prepare an SQL statement with db:prepare
Get column names with stmt:get_names or similar
Step through each row with stmt:step
Get column values with stmt:get_values or similar
After all rows are extracted, finalize the statement with stmt:finalize
Close the database with db:close
Numerical error and result codes
The following constants are defined by module sqlite3:
For details about their exact meaning please see the SQLite3 documentation http://www.sqlite.org/.
context:aggregate_count - Returns the number of calls to the aggregate step function.
(Help topic: general=lua_sqlite3)
Enter a search string to find matching documentation.
Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.
Gammon Software support
Forum RSS feed ( https://gammon.com.au/rss/forum.xml )