/ Check-in [9322c439]
Login

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

Overview
Comment:Documentation updates (CVS 1921)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 9322c439c5727f0d65548efdf4de4d7b89b4be66
User & Date: drh 2004-08-30 14:58:12
Context
2004-08-30
16:52
Better detection and handling of corrupt database files. (CVS 1922) check-in: 8f5b199e user: drh tags: trunk
14:58
Documentation updates (CVS 1921) check-in: 9322c439 user: drh tags: trunk
14:22
Remove the \001 character that lemon inserts automatically in its output file. The need for this character has expired and it creates confusion for users. Ticket #877 (CVS 1920) check-in: acfc5918 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to www/c_interface.tcl.

     1      1   #
     2      2   # Run this Tcl script to generate the sqlite.html file.
     3      3   #
     4         -set rcsid {$Id: c_interface.tcl,v 1.40 2004/05/31 15:06:29 drh Exp $}
            4  +set rcsid {$Id: c_interface.tcl,v 1.41 2004/08/30 14:58:12 drh Exp $}
     5      5   source common.tcl
     6      6   header {The C language interface to the SQLite library}
     7      7   puts {
     8      8   <h2>The C language interface to the SQLite library</h2>
     9      9   
    10     10   <p>The SQLite library is designed to be very easy to use from
    11     11   a C or C++ program.  This document gives an overview of the C/C++
................................................................................
   691    691   pointer. In addition to the regular data, there is an added row at the 
   692    692   beginning of the array that contains the name of each column of the
   693    693   result.</p>
   694    694   
   695    695   <p>As an example, consider the following query:</p>
   696    696   
   697    697   <blockquote>
   698         -SELECT employee_name, login, host FROM users WHERE logic LIKE 'd%';
          698  +SELECT employee_name, login, host FROM users WHERE login LIKE 'd%';
   699    699   </blockquote>
   700    700   
   701    701   <p>This query will return the name, login and host computer name
   702    702   for every employee whose login begins with the letter "d".  If this
   703    703   query is submitted to <b>sqlite_get_table</b> the result might
   704    704   look like this:</p>
   705    705   

Changes to www/nulls.tcl.

     1      1   #
     2      2   # Run this script to generated a nulls.html output file
     3      3   #
     4         -set rcsid {$Id: nulls.tcl,v 1.6 2004/05/31 15:06:30 drh Exp $}
            4  +set rcsid {$Id: nulls.tcl,v 1.7 2004/08/30 14:58:12 drh Exp $}
     5      5   source common.tcl
     6      6   header {NULL Handling in SQLite}
     7      7   puts {
     8      8   <h2>NULL Handling in SQLite Versus Other Database Engines</h2>
     9      9   
    10     10   <p>
    11     11   The goal is
................................................................................
   103    103   <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
   104    104   </tr>
   105    105   <tr><td>nulls are distinct in a UNIQUE column</td>
   106    106   <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
   107    107   <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
   108    108   <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
   109    109   <td valign="center" align="center" bgcolor="#c7a9a9">No</td>
   110         -<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
          110  +<td valign="center" align="center" bgcolor="#aaaad2">(Note 4)</td>
   111    111   <td valign="center" align="center" bgcolor="#c7a9a9">No</td>
   112    112   <td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
   113    113   </tr>
   114    114   <tr><td>nulls are distinct in SELECT DISTINCT</td>
   115    115   <td valign="center" align="center" bgcolor="#c7a9a9">No</td>
   116    116   <td valign="center" align="center" bgcolor="#c7a9a9">No</td>
   117    117   <td valign="center" align="center" bgcolor="#c7a9a9">No</td>
................................................................................
   235    235   <tr><td>2.&nbsp;</td>
   236    236   <td>Test data unavailable.</td>
   237    237   </tr>
   238    238   <tr><td>3.&nbsp;</td>
   239    239   <td>MySQL version 3.23.41 does not support UNION.</td>
   240    240   </tr>
   241    241   <tr><td>4.&nbsp;</td>
   242         -<td>SQL Anywhere and Borland Interbase 
          242  +<td>DB2, SQL Anywhere, and Borland Interbase 
   243    243   do not allow NULLs in a UNIQUE column.</td>
   244    244   </tr>
   245    245   <tr><td>5.&nbsp;</td>
   246    246   <td>Borland Interbase does not support CASE expressions.</td>
   247    247   </tr>
   248    248   </table>
   249    249   <br clear="both">