nstcl-database Package

• configure_pool:
      Configure a database pool

• load_driver:
      Load a database driver

• set_default_pool:
      Sets a default database pool

• database_api:
      The nstcl database api

• database_to_tcl_list:
      Performs an SQL query and returns a list of results

• database_to_tcl_string:
      Get a single result as a string from a database query

• database_to_tcl_string_or_null:
      Returns one (possibly non-existant) value from an SQL query

• db_0or1row:
      Set variables for a query returning at most one row

• db_1row:
      Set variables for a query returning exactly one row

• db_abort_transaction:
      Abort a database transaction

• db_abort_transaction_p:
      Returns boolean abortion status

• db_continue_transaction:
      Continue a transaction that was to be aborted

• db_dml:
      Executes a DML statement

• db_foreach:
      Execute a block of code for each result row from a SQL query

• db_list:
      Returns a list of the first column from an SQL query

• db_list_of_lists:
      Evaluates an SQL query and returns the results as a list of lists

• db_multirow:
      Create a multirow templating datasource from an SQL query

• db_quote:
      Double-up any single quotes in a string

• db_string:
      Returns the first column from an SQL query

• db_transaction:
      Execute database statements within a transaction

• DoubleApos:
      Double-up any single quotes in a string

• ns_db:
      Access a database

• ns_dbquotename:
      Possibly quotes the name of a database column

• ns_dbquotevalue:
      Prepares a value string for inclusion in an SQL statement

• ns_localsqltimestamp:
      Returns the current local time in SQL timestamp format