/ Check-in [6a76bd95]
Login

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:6a76bd9590f372411e697f002285fe36ff3787ee
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
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/sqlite.tcl.

     1      1   #
     2      2   # Run this Tcl script to generate the sqlite.html file.
     3      3   #
     4         -set rcsid {$Id: sqlite.tcl,v 1.19 2003/05/04 07:31:10 jplyon Exp $}
            4  +set rcsid {$Id: sqlite.tcl,v 1.20 2003/05/10 02:54:57 jplyon Exp $}
     5      5   
     6      6   puts {<html>
     7      7   <head>
     8      8     <title>sqlite: A program of interacting with SQLite databases</title>
     9      9   </head>
    10     10   <body bgcolor=white>
    11     11   <h1 align=center>
................................................................................
   560    560   Code {
   561    561   $ (((sqlite ex1 'select * from tbl1' |)))
   562    562   > ((( awk '{printf "<tr><td>%s<td>%s\n",$1,$2 }')))
   563    563   <tr><td>hello<td>10
   564    564   <tr><td>goodbye<td>20
   565    565   $
   566    566   }
          567  +
          568  +puts {
          569  +<h2>Ending shell commands</h2>
          570  +
          571  +<p>
          572  +SQLite commands are normally terminated by a semicolon.  In the shell 
          573  +you can also use the word "GO" (case-insensitive) or a backslash character 
          574  +"\" on a line by itself to end a command.  These are used by SQL Server 
          575  +and Oracle, respectively.  These won't work in <b>sqlite_exec()</b>, 
          576  +because the shell translates these into a semicolon before passing them 
          577  +to that function.</p>
          578  +}
   567    579   
   568    580   puts {
   569    581   <h2>Compiling the sqlite program from sources</h2>
   570    582   
   571    583   <p>
   572    584   The sqlite program is built automatically when you compile the
   573    585   sqlite library.  Just get a copy of the source tree, run