You may use the nav bar to the left to select pages.
Below is a listing of all commands and a brief description for each.
Do find/replace on a column of a SQL table.
Find entry in the globals table and decrement it.
Run a SELECT, map results to variables, and execute body.
Find and return value of entry in globals table.
Increase the value of an entry in the global table by one.
Find last id in the table and return it.
Put trace on variable so the database global gets writ also.
Execute a query and return the first field of first record.
Run the query with configured database and return result.
Create SQL table using table name and column names/types.
Do an update if an entry exists or an insert if not.
Do an insert unless an entry already exists.
Finds an entry in the global table and sets it to a value.
Print the contents of a table.
Create a SELECT count(1) statement, use dict for WHERE.
Create an INSERT INTO statement.
Tell if record exists in given table, matching criteria.
Make and return a SQL SELECT statement.
Derive a set clause for an update query, using a dict.
Create an UPDATE statement.
Create a WHERE clause using the values in dict.
Return the names and types of the columns of some table.
Return a Tcl list with the names of the columns of a table.
Get the data type for the column in the table.
Copy a table in a SQLite database.
Change name of a column in an SQLite table.
Determine if a table exists in the current database.
Stop making writes to the variable also write the database.
Unset / delete a variable in the globals table.