|
Index[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] table_info directive (PRAGMA command) tables adding adding data to 2nd 3rd 4th 5th 6th SELECT query results 2nd single rows 2nd altering 2nd binary data 2nd BLOBs 2nd browsing columns aliases 2nd constraints 2nd DEFAULT defining 2nd NOT NULL 2nd PRIMARY KEY UNIQUE conflict resolution 2nd 3rd 4th copying creating 2nd 3rd creating with Perl DBI 2nd data types 2nd 3rd dates 2nd dropping 2nd 3rd full table scan INTEGER PRIMARY KEY columns 2nd joins 2nd 3rd 4th 5th Cartesian joins 2nd left joins 2nd 3rd records adding with Tcl interface 2nd 3rd 4th 5th fetching with Tcl interface 2nd 3rd rows inserting with Tcl interface 2nd schemas viewing 2nd searching SQLite Database Browser sqlite_master 2nd 3rd temporary tables 2nd updating 2nd Tcl commands dbcmd busy callback dbcmd changes 2nd dbcmd complete dbcmd errorcode dbcmd eval query 2nd dbcmd function dbcmd onecolumn dbcmd timeout sqlite close sqlite dbcmd sqlite_version convenience functions custom functions, registering databases opening/closing 2nd error reporting libtclsqlite.so library 2nd locked database files, handling 2nd queries executing 2nd finding information about 2nd SQL statements checking SQLite version, finding Tcl (Tool Command Language) interface 2nd 3rd databases adding records to 2nd 3rd 4th 5th closing 2nd fetching records from 2nd 3rd opening 2nd timeouts 2nd downloading methods busy changes 2nd close complete 2nd eval 2nd 3rd function 2nd 3rd last_insert_rowid onecolumn reverse reverse_string string map timeout 2nd SQL statements, executing 2nd SQL statements, validating 2nd 3rd user-defined functions, registering 2nd 3rd Tcl interface tclsqlite-2.8.15.so.gz package tclsqlite-2_8_15.zip file tclsqlite.so.gz library tclsqlite.so.gz package tclsqlite.zip library tclsqlite.zip package temp_store directive (PRAGMA command) temporary tables 2nd text strings comparing 2nd 3rd TEXT data type 2nd THREADSAFE preprocessor macro time zones 2nd time() function time-tracking sample database adding data to 2nd 3rd 4th 5th binary data 2nd BLOBs 2nd data types 2nd 3rd dates 2nd INTEGER PRIMARY KEY columns 2nd tables 2nd 3rd timeout argument (sqlite.connect() command) timeout method 2nd timeouts 2nd 3rd 4th 5th setting Tcl interface 2nd times/dates 2nd date() function date/time conversion specifiers datetime() function displaying 2nd jullianday() function modifiers 2nd 3rd strftime() function 2nd time string formats 2nd time zones 2nd time() function tokenizers tools [See names of specific tools] pear 2nd trace() function 2nd 3rd 4th 5th tracing Perl DBI Perl DBI (Database Interface) 2nd 3rd 4th traffic transactions 2nd 3rd 4th 5th 6th 7th 8th 9th beginning begin_work() function 2nd committing commit() function 2nd nesting PySQLite interface 2nd rolling back rollback() function 2nd triggers creating 2nd 3rd 4th defined dropping 2nd 3rd example 2nd interrupting 2nd limitations triggers on views 2nd troubleshooting SQLite error codes 2nd 3rd 4th typeless data types 2nd 3rd types 2nd 3rd |
|