Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Use "package require" rather than "load" on the quick-start guide to using SQLite from TCL. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
12ac1ca27ff6ff72c2a528f1d238bef1 |
| User & Date: | drh 2013-03-18 21:05:08 |
Context
|
2013-03-18
| ||
| 21:37 | Update the documentation on the SQLite TCL interface to talk about options to the "sqlite3" command and the "wal_hook" method. check-in: c00d5a996d user: drh tags: trunk | |
| 21:05 | Use "package require" rather than "load" on the quick-start guide to using SQLite from TCL. check-in: 12ac1ca27f user: drh tags: trunk | |
| 19:47 | Add Tcl/Tk to the set of well-known-users of SQLite. check-in: 6ab45fc348 user: drh tags: trunk | |
Changes
Changes to pages/quickstart.in.
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
<ul> <li><p>Below is a simple [http://www.tcl.tk | TCL program] that demonstrates how to use the TCL interface to SQLite. The program executes the SQL statements given as the second argument on the database defined by the first argument. The commands to watch for are the <b>sqlite3</b> command on line 7 which opens an SQLite database and creates a new TCL command named "<b>db</b>" to access that database, the invocation of the <b>db</b> command on line 8 to execute SQL commands against the database, and the closing of the database connection on the last line of the script.</p> <blockquote><pre> 01 #!/usr/bin/tclsh 02 if {$argc!=2} { 03 puts stderr "Usage: %s DATABASE SQL-STATEMENT" 04 exit 1 05 } 06 load /usr/lib/tclsqlite3.so Sqlite3 07 <b>sqlite3</b> db [lindex $argv 0] 08 <b>db</b> eval [lindex $argv 1] x { 09 foreach v $x(*) { 10 puts "$v = $x($v)" 11 } 12 puts "" 13 } |
| | | |
28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
<ul> <li><p>Below is a simple [http://www.tcl.tk | TCL program] that demonstrates how to use the TCL interface to SQLite. The program executes the SQL statements given as the second argument on the database defined by the first argument. The commands to watch for are the <b>sqlite3</b> command on line 7 which opens an SQLite database and creates a new object named "<b>db</b>" to access that database, the use of the [eval method] on the <b>db</b> object on line 8 to run SQL commands against the database, and the closing of the database connection on the last line of the script.</p> <blockquote><pre> 01 #!/usr/bin/tclsh 02 if {$argc!=2} { 03 puts stderr "Usage: %s DATABASE SQL-STATEMENT" 04 exit 1 05 } 06 package require sqlite3 07 <b>sqlite3</b> db [lindex $argv 0] 08 <b>db</b> eval [lindex $argv 1] x { 09 foreach v $x(*) { 10 puts "$v = $x($v)" 11 } 12 puts "" 13 } |
Changes to pages/tclsqlite.in.
1 2 3 4 5 6 7 8 9 10 11 12 |
<title>The Tcl interface to the SQLite library</title>
<tcl>
hd_keywords {Tcl extension} {TCL Interface}
proc METHOD {name text} {
hd_puts "<a name=\"$name\"></a>\n<h3>The \"$name\" method</h3>\n"
hd_resolve $text
}
</tcl>
<h1 align=center>The Tcl interface to the SQLite library</h1>
<p>The SQLite library is designed to be very easy to use from
|
> | |
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<title>The Tcl interface to the SQLite library</title>
<tcl>
hd_keywords {Tcl extension} {TCL Interface}
proc METHOD {name text} {
hd_fragment $name [list $name method] [list TCL interface $name method]
hd_puts "<h3>The \"$name\" method</h3>\n"
hd_resolve $text
}
</tcl>
<h1 align=center>The Tcl interface to the SQLite library</h1>
<p>The SQLite library is designed to be very easy to use from
|