SNOBOL4SQLITE3(3) CSNOBOL4 Manual SNOBOL4SQLITE3(3) NAME snobol4sqlite3 - SQLITE3 interface for SNOBOL4 SYNOPSYS -INCLUDE 'sqlite3.sno' DESCRIPTION SQLITE3_OPEN(path) opens a database and returns a database handle or failure. SQLITE3_CLOSE(db_handle) closes database and returns empty string or failure. SQLITE3_ERRMSG(db_handle) Returns an SQLITE3 error string or failure if the handle is invalid. SQLITE3_LAST_INSERT_ROWID(db_handle) Returns an integer or failure if the handle is invalid. SQLITE3_PREPARE(db_handle,SQL[,params ...]) Parses an SQL statement and optionally binds positional parameters to it. Call SQLITE3_ROW_ARRAY() or SQLITE3_ROW_TABLE() to fetch a row of results once all parameters have been bound. Returns a statement han- dle or failure. SQLITE3_BIND_ANY(st_handle, position, value) Binds value at (one-based) position to a prepared SQL statement. Re- turns null string or failure. SQLITE3_BIND_BLOB(st_handle, position, value) Binds value to (one-based) position as a BLOB value to prepared SQL statement. Returns null string or failure. SQLITE3_BIND_MANY(st_handle, values ...) Binds multiple positional parameter values to a prepared SQL statement. Returns null string or failure. SQLITE3_BIND_PARAMETER_COUNT(st_handle) Returns the number of parameters required by a prepared SQL statement, or fails. SQLITE3_BIND_PARAMETER_NAME(st_handle, position) Returns the name (if any) for the parameter position number in a pre- pared SQL statement. SQLITE3_BIND_PARAMETER_INDEX(st_handle, name) Returns the positional index for named parameter name in prepared SQL statement. SQLITE3_CLEAR_BINDINGS(st_handle) Use this routine to reset all parameter bindings to NULL. SQLITE3_RESET(st_handle) Reset a prepared statement back to its initial state, ready to be re- executed. Any SQL statement variables that had values bound to them re- tain their values. Use sqlite3_clear_bindings() to reset the bindings. SQLITE3_FINALIZE(st_handle) Release (delete) a statement handle. SQLITE3_EXEC(db_handle,SQL statement(s)) Run one or more SQL statements that do not require parameters. SQLITE3_ROW_ARRAY(st_handle) Returns an ARRAY with a row of statement results or fails. SQLITE3_COLUMN_NAMES_ARRAY(st_handle) Returns an ARRAY with SQL statement result column names or fails. SQLITE3_ROW_TABLE(st_handle) Returns a TABLE with statement results indexed by column name or fails. SEE ALSO snobol4(1), sqlite3(1) http://www.sqlite.org http://www.sqlite.org/c3ref/funclist.html CSNOBOL4B 2.3.1 March 31, 2022 SNOBOL4SQLITE3(3)
NAME | SYNOPSYS | DESCRIPTION | SEE ALSO
Want to link to this manual page? Use this URL:
<https://man.FreeBSD.org/cgi/man.cgi?query=snobol4sqlite3&sektion=3&manpath=FreeBSD+Ports+15.1.quarterly>