Tcl/Tk in a Nutshell

Group Listing of Commands

Connection and Configuration Commands

database connect	Connect to an ODBC database.
database configure	Configure ODBC datasources.
database datasources	Return a list of ODBC datasources.
database drivers	Return a list of ODBC drivers.

Data Manipulation Commands

In the following commands, database-id is the database identifier for a database connection created using the database connect command:

database-id SQL-clause	Execute an SQL statement.
database-id disconnect	Disconnect from the database.
database-id set	Set connection-specific attributes.
database-id get	Get connection-specific attributes.
database-id commit	Commit current transaction.
database-id rollback	Cancel current transaction.
database-id tables	Return a list of database tables.
database-id columns	Return a list of database columns.
database-id indexes	Return a list of database indexes.
database-id statement	Create a statement object.

Statement Commands

In the following commands, statement-id is a statement identifier created using the database-id statement command:

statement-id run

Execute the statement and return results.

statement-id execute [args]

Execute the statement without returning results.

statement-id fetch [arrayName] [columnNames]

With no parameters, read one row, returning the results or an empty string when there are no more results to be read. With an array name, read the results into an array. Column names can optionally be specified.

statement-id columns

Return a list of statement column attributes.

statement-id ...