Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Documented the "GO" and "\" command terminators. (CVS 963) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
6a76bd9590f372411e697f002285fe36 |
| User & Date: | jplyon 2003-05-10 02:54:57 |
Context
|
2003-05-10
| ||
| 03:03 | Removed never-used pragma "result_set_details". (CVS 964) check-in: bf558e79 user: jplyon tags: trunk | |
| 02:54 | Documented the "GO" and "\" command terminators. (CVS 963) check-in: 6a76bd95 user: jplyon tags: trunk | |
| 02:54 | Fixed metacharacter coloring with LP, RP, PLUS. Added more links. (CVS 962) check-in: 2bbb0804 user: jplyon tags: trunk | |
Changes
Changes to www/sqlite.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
560
561
562
563
564
565
566
567
568
569
570
571
572
573
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: sqlite.tcl,v 1.19 2003/05/04 07:31:10 jplyon Exp $}
puts {<html>
<head>
<title>sqlite: A program of interacting with SQLite databases</title>
</head>
<body bgcolor=white>
<h1 align=center>
................................................................................
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
|
|
>
>
>
>
>
>
>
>
>
>
>
>
|
1
2
3
4
5
6
7
8
9
10
11
...
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
|
#
# 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>
................................................................................
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
|