/ Check-in [2ffb90c3]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Documentation updates. (CVS 2796)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2ffb90c39d0b60de9a692326ca3f2595c1fc97d0
User & Date: drh 2005-12-02 01:57:43
Context
2005-12-02
02:44
Add a test to verify that binding text with embedded '\000' works. Also comment changes in os.h. (CVS 2797) check-in: 31251a90 user: drh tags: trunk
01:57
Documentation updates. (CVS 2796) check-in: 2ffb90c3 user: drh tags: trunk
2005-11-30
03:20
Restructure the OS interface yet again. This time make the OsFile object a virtual base class which is subclassed for unix, windows, and the crash test simulator. Add the new file "os.c" for common os layer code. Move all OS-specific routines into the sqlite3Os structure. (CVS 2795) check-in: bd8740d1 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/capi3ref.tcl.

     1         -set rcsid {$Id: capi3ref.tcl,v 1.24 2005/07/22 22:53:16 drh Exp $}
            1  +set rcsid {$Id: capi3ref.tcl,v 1.25 2005/12/02 01:57:43 drh Exp $}
     2      2   source common.tcl
     3      3   header {C/C++ Interface For SQLite Version 3}
     4      4   puts {
     5      5   <h2>C/C++ Interface For SQLite Version 3</h2>
     6      6   }
     7      7   
     8      8   proc api {name prototype desc {notused x}} {
................................................................................
   122    122    fifth argument has the value SQLITE_TRANSIENT, then SQLite makes its
   123    123    own private copy of the data before returning.
   124    124   
   125    125    The sqlite3_bind_*() routines must be called after
   126    126    sqlite3_prepare() or sqlite3_reset() and before sqlite3_step().
   127    127    Bindings are not cleared by the sqlite3_reset() routine.
   128    128    Unbound parameters are interpreted as NULL.
          129  +
          130  + These routines return SQLITE_OK on success or an error code if
          131  + anything goes wrong.  SQLITE_RANGE is returned if the parameter
          132  + index is out of range.  SQLITE_NOMEM is returned if malloc fails.
          133  + SQLITE_MISUSE is returned if these routines are called on a virtual
          134  + machine that is the wrong state or which has already been finalized.
   129    135   }
   130    136   
   131    137   api {} {
   132    138     int sqlite3_bind_parameter_count(sqlite3_stmt*);
   133    139   } {
   134    140     Return the number of parameters in the precompiled statement given as
   135    141     the argument.

Changes to www/quickstart.tcl.

     1      1   #
     2      2   # Run this TCL script to generate HTML for the quickstart.html file.
     3      3   #
     4         -set rcsid {$Id: quickstart.tcl,v 1.6 2004/10/19 01:31:20 drh Exp $}
            4  +set rcsid {$Id: quickstart.tcl,v 1.7 2005/12/02 01:57:43 drh Exp $}
     5      5   source common.tcl
     6      6   header {SQLite In 5 Minutes Or Less}
     7      7   puts {
     8      8   <p>Here is what you do to start experimenting with SQLite without having
     9      9   to do a lot of tedious reading and configuration:</p>
    10     10   
    11     11   <h2>Download The Code</h2>
................................................................................
    20     20   
    21     21   <ul>
    22     22   <li><p>At a shell or DOS prompt, enter: "<b>sqlite3 test.db</b>".  This will
    23     23   create a new database named "test.db".  (You can use a different name if
    24     24   you like.)</p></li>
    25     25   <li><p>Enter SQL commands at the prompt to create and populate the
    26     26   new database.</p></li>
           27  +<li><p>Additional documentation is available <a href="sqlite.html">here</a></li>
    27     28   </ul>
    28     29   
    29     30   <h2>Write Programs That Use SQLite</h2>
    30     31   
    31     32   <ul>
    32     33   <li><p>Below is a simple TCL program that demonstrates how to use
    33     34   the TCL interface to SQLite.  The program executes the SQL statements
................................................................................
   101    102     <b>sqlite3_close</b>(db);
   102    103     return 0;
   103    104   }
   104    105   </pre></blockquote>
   105    106   </li>
   106    107   </ul>
   107    108   }
   108         -footer {$Id: quickstart.tcl,v 1.6 2004/10/19 01:31:20 drh Exp $}
          109  +footer {$Id: quickstart.tcl,v 1.7 2005/12/02 01:57:43 drh Exp $}

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.22 2004/05/31 15:06:30 drh Exp $}
            4  +set rcsid {$Id: sqlite.tcl,v 1.23 2005/12/02 01:57:43 drh Exp $}
     5      5   source common.tcl
     6         -header {sqlite: A program of interacting with SQLite databases}
            6  +header {sqlite: A command-line access program for SQLite databases}
     7      7   puts {
     8         -<h2>sqlite: A command-line program to administer SQLite databases</h2>
            8  +<h2>sqlite: A command-line access program for SQLite databases</h2>
     9      9   
    10     10   <p>The SQLite library includes a simple command-line utility named
    11     11   <b>sqlite</b> that allows the user to manually enter and execute SQL
    12     12   commands against an SQLite database.  This document provides a brief
    13     13   introduction on how to use <b>sqlite</b>.
    14     14   
    15     15   <h3>Getting Started</h3>