1SNOBOL4SQLITE3(3)               CSNOBOL4 Manual              SNOBOL4SQLITE3(3)
2
3
4

NAME

6       snobol4sqlite3 - SQLITE3 interface for SNOBOL4
7

SYNOPSYS

9       -INCLUDE 'sqlite3.sno'
10

DESCRIPTION

12       SQLITE3_OPEN(path)
13           opens a database and returns a database handle or failure.
14
15       SQLITE3_CLOSE(db_handle)
16           closes database and returns empty string or failure.
17
18       SQLITE3_ERRMSG(db_handle)
19           Returns an SQLITE3 error string or failure if the handle is
20           invalid.
21
22       SQLITE3_LAST_INSERT_ROWID(db_handle)
23           Returns an integer or failure if the handle is invalid.
24
25       SQLITE3_PREPARE(db_handle,SQL[,params ...])
26           Parses an SQL statement and optionally binds positional parameters
27           to it.  Call SQLITE3_ROW_ARRAY() or SQLITE3_ROW_TABLE() to fetch a
28           row of results once all parameters have been bound.  Returns a
29           statement handle or failure.
30
31       SQLITE3_BIND_ANY(st_handle, position, value)
32           Binds value at (one-based) position to a prepared SQL statement.
33           Returns null string or failure.
34
35       SQLITE3_BIND_BLOB(st_handle, position, value)
36           Binds value to (one-based) position as a BLOB value to prepared SQL
37           statement.  Returns null string or failure.
38
39       SQLITE3_BIND_MANY(st_handle, values ...)
40           Binds multiple positional parameter values to a prepared SQL
41           statement.  Returns null string or failure.
42
43       SQLITE3_BIND_PARAMETER_COUNT(st_handle)
44           Returns the number of parameters required by a prepared SQL
45           statement, or fails.
46
47       SQLITE3_BIND_PARAMETER_NAME(st_handle, position)
48           Returns the name (if any) for the parameter position number in a
49           prepared SQL statement.
50
51       SQLITE3_BIND_PARAMETER_INDEX(st_handle, name)
52           Returns the positional index for named parameter name in prepared
53           SQL statement.
54
55       SQLITE3_CLEAR_BINDINGS(st_handle)
56           Use this routine to reset all parameter bindings to NULL.
57
58       SQLITE3_RESET(st_handle)
59           Reset a prepared statement back to its initial state, ready to be
60           re-executed. Any SQL statement variables that had values bound to
61           them retain their values. Use sqlite3_clear_bindings() to reset the
62           bindings.
63
64       SQLITE3_FINALIZE(st_handle)
65           Release (delete) a statement handle.
66
67       SQLITE3_EXEC(db_handle,SQL statement(s))
68           Run one or more SQL statements that do not require parameters.
69
70       SQLITE3_ROW_ARRAY(st_handle)
71           Returns an ARRAY with a row of statement results or fails.
72
73       SQLITE3_COLUMN_NAMES_ARRAY(st_handle)
74           Returns an ARRAY with SQL statement result column names or fails.
75
76       SQLITE3_ROW_TABLE(st_handle)
77           Returns a TABLE with statement results indexed by column name or
78           fails.
79

SEE ALSO

81       snobol4(1), sqlite3(1)
82       http://www.sqlite.org
83       http://www.sqlite.org/c3ref/funclist.html
84
85
86
87CSNOBOL4B 2.3.1                 March 31, 2022               SNOBOL4SQLITE3(3)