Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Documented the "GO" and "\" command terminators. (CVS 963) |
|---|---|
| Downloads: | Tarball | ZIP archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
6a76bd9590f372411e697f002285fe36 |
| User & Date: | jplyon 2003-05-10 02:54:57.000 |
Context
|
2003-05-10
| ||
| 03:03 | Removed never-used pragma "result_set_details". (CVS 964) (check-in: bf558e7952 user: jplyon tags: trunk) | |
| 02:54 | Documented the "GO" and "\" command terminators. (CVS 963) (check-in: 6a76bd9590 user: jplyon tags: trunk) | |
| 02:54 | Fixed metacharacter coloring with LP, RP, PLUS. Added more links. (CVS 962) (check-in: 2bbb080495 user: jplyon tags: trunk) | |
Changes
Changes to www/sqlite.tcl.
1 2 3 | # # Run this Tcl script to generate the sqlite.html file. # | | | 1 2 3 4 5 6 7 8 9 10 11 |
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: sqlite.tcl,v 1.20 2003/05/10 02:54:57 jplyon Exp $}
puts {<html>
<head>
<title>sqlite: A program of interacting with SQLite databases</title>
</head>
<body bgcolor=white>
<h1 align=center>
|
| ︙ | ︙ | |||
560 561 562 563 564 565 566 567 568 569 570 571 572 573 |
Code {
$ (((sqlite ex1 'select * from tbl1' |)))
> ((( awk '{printf "<tr><td>%s<td>%s\n",$1,$2 }')))
<tr><td>hello<td>10
<tr><td>goodbye<td>20
$
}
puts {
<h2>Compiling the sqlite program from sources</h2>
<p>
The sqlite program is built automatically when you compile the
sqlite library. Just get a copy of the source tree, run
| > > > > > > > > > > > > | 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 |
Code {
$ (((sqlite ex1 'select * from tbl1' |)))
> ((( awk '{printf "<tr><td>%s<td>%s\n",$1,$2 }')))
<tr><td>hello<td>10
<tr><td>goodbye<td>20
$
}
puts {
<h2>Ending shell commands</h2>
<p>
SQLite commands are normally terminated by a semicolon. In the shell
you can also use the word "GO" (case-insensitive) or a backslash character
"\" on a line by itself to end a command. These are used by SQL Server
and Oracle, respectively. These won't work in <b>sqlite_exec()</b>,
because the shell translates these into a semicolon before passing them
to that function.</p>
}
puts {
<h2>Compiling the sqlite program from sources</h2>
<p>
The sqlite program is built automatically when you compile the
sqlite library. Just get a copy of the source tree, run
|
| ︙ | ︙ |