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: |
9322c439c5727f0d65548efdf4de4d7b |
| 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
Changes to www/c_interface.tcl.
1
2
3
4
5
6
7
8
9
10
11
...
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: c_interface.tcl,v 1.40 2004/05/31 15:06:29 drh Exp $}
source common.tcl
header {The C language interface to the SQLite library}
puts {
<h2>The C language interface to the SQLite library</h2>
<p>The SQLite library is designed to be very easy to use from
a C or C++ program. This document gives an overview of the C/C++
................................................................................
pointer. In addition to the regular data, there is an added row at the
beginning of the array that contains the name of each column of the
result.</p>
<p>As an example, consider the following query:</p>
<blockquote>
SELECT employee_name, login, host FROM users WHERE logic LIKE 'd%';
</blockquote>
<p>This query will return the name, login and host computer name
for every employee whose login begins with the letter "d". If this
query is submitted to <b>sqlite_get_table</b> the result might
look like this:</p>
|
|
|
|
1
2
3
4
5
6
7
8
9
10
11
...
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
|
#
# Run this Tcl script to generate the sqlite.html file.
#
set rcsid {$Id: c_interface.tcl,v 1.41 2004/08/30 14:58:12 drh Exp $}
source common.tcl
header {The C language interface to the SQLite library}
puts {
<h2>The C language interface to the SQLite library</h2>
<p>The SQLite library is designed to be very easy to use from
a C or C++ program. This document gives an overview of the C/C++
................................................................................
pointer. In addition to the regular data, there is an added row at the
beginning of the array that contains the name of each column of the
result.</p>
<p>As an example, consider the following query:</p>
<blockquote>
SELECT employee_name, login, host FROM users WHERE login LIKE 'd%';
</blockquote>
<p>This query will return the name, login and host computer name
for every employee whose login begins with the letter "d". If this
query is submitted to <b>sqlite_get_table</b> the result might
look like this:</p>
|
Changes to www/nulls.tcl.
1 2 3 4 5 6 7 8 9 10 11 ... 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 ... 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 |
#
# Run this script to generated a nulls.html output file
#
set rcsid {$Id: nulls.tcl,v 1.6 2004/05/31 15:06:30 drh Exp $}
source common.tcl
header {NULL Handling in SQLite}
puts {
<h2>NULL Handling in SQLite Versus Other Database Engines</h2>
<p>
The goal is
................................................................................
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
</tr>
<tr><td>nulls are distinct in a UNIQUE column</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
</tr>
<tr><td>nulls are distinct in SELECT DISTINCT</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
................................................................................
<tr><td>2. </td>
<td>Test data unavailable.</td>
</tr>
<tr><td>3. </td>
<td>MySQL version 3.23.41 does not support UNION.</td>
</tr>
<tr><td>4. </td>
<td>SQL Anywhere and Borland Interbase
do not allow NULLs in a UNIQUE column.</td>
</tr>
<tr><td>5. </td>
<td>Borland Interbase does not support CASE expressions.</td>
</tr>
</table>
<br clear="both">
|
| | | |
1 2 3 4 5 6 7 8 9 10 11 ... 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 ... 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 |
#
# Run this script to generated a nulls.html output file
#
set rcsid {$Id: nulls.tcl,v 1.7 2004/08/30 14:58:12 drh Exp $}
source common.tcl
header {NULL Handling in SQLite}
puts {
<h2>NULL Handling in SQLite Versus Other Database Engines</h2>
<p>
The goal is
................................................................................
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
</tr>
<tr><td>nulls are distinct in a UNIQUE column</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#aaaad2">(Note 4)</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#a9c7a9">Yes</td>
</tr>
<tr><td>nulls are distinct in SELECT DISTINCT</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
<td valign="center" align="center" bgcolor="#c7a9a9">No</td>
................................................................................
<tr><td>2. </td>
<td>Test data unavailable.</td>
</tr>
<tr><td>3. </td>
<td>MySQL version 3.23.41 does not support UNION.</td>
</tr>
<tr><td>4. </td>
<td>DB2, SQL Anywhere, and Borland Interbase
do not allow NULLs in a UNIQUE column.</td>
</tr>
<tr><td>5. </td>
<td>Borland Interbase does not support CASE expressions.</td>
</tr>
</table>
<br clear="both">
|