sqlite

Functions for working with SQLite relational databases.

Summary
sqliteFunctions for working with SQLite relational databases.
Types
DatabaseOpaque type representing a SQLite database.
RowRepresents a row in a results.
RowsRepresents a query result set.
Functions
openOpen a database in the given named file.
execExecute a SQL statement in the given database and return the result set.
execRawExecute a SQL statement in the given database and return the result set.
closeClose a database.

Types

Database

Opaque type representing a SQLite database.

Row

Represents a row in a results.

Rows

Represents a query result set.

Functions

open

DECLARE NATIVE FUNCTION open(name: String): Database

Open a database in the given named file.

exec

DECLARE NATIVE FUNCTION exec(db: Database,
sql: String,
parameters: Dictionary<String>): Rows

Execute a SQL statement in the given database and return the result set.

execRaw

DECLARE NATIVE FUNCTION execRaw(db: Database,
sql: String): Rows

Execute a SQL statement in the given database and return the result set.

close

DECLARE NATIVE FUNCTION close(db: Database)

Close a database.

DECLARE NATIVE FUNCTION open(name: String): Database
Open a database in the given named file.
DECLARE NATIVE FUNCTION exec(db: Database,
sql: String,
parameters: Dictionary<String>): Rows
Execute a SQL statement in the given database and return the result set.
DECLARE NATIVE FUNCTION execRaw(db: Database,
sql: String): Rows
Execute a SQL statement in the given database and return the result set.
DECLARE NATIVE FUNCTION close(db: Database)
Close a database.
Close