GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages
SNOBOL4SQLITE3(3) CSNOBOL4 Manual SNOBOL4SQLITE3(3)

snobol4sqlite3 - SQLITE3 interface for SNOBOL4

-INCLUDE 'sqlite3.sno'

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 handle or failure.
SQLITE3_BIND_ANY(st_handle, position, value)
Binds value at (one-based) position to a prepared SQL statement. Returns 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 prepared 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 retain 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.

snobol4(1), sqlite3(1)
http://www.sqlite.org
http://www.sqlite.org/c3ref/funclist.html
March 31, 2022 CSNOBOL4B 2.3.1

Search for    or go to Top of page |  Section 3 |  Main Index

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with ManDoc.