Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | :-) (CVS 60) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
4eca3bf64fd96303bee653b7e44fa7bb |
User & Date: | drh 2000-06-06 18:24:42.000 |
Context
2000-06-06
| ||
19:18 | :-) (CVS 61) (check-in: 25984b4d3c user: drh tags: trunk) | |
18:24 | :-) (CVS 60) (check-in: 4eca3bf64f user: drh tags: trunk) | |
18:00 | :-) (CVS 59) (check-in: a8fa6719d5 user: drh tags: trunk) | |
Changes
Changes to www/c_interface.tcl.
1 2 3 | # # Run this Tcl script to generate the sqlite.html file. # | | | 1 2 3 4 5 6 7 8 9 10 11 | # # Run this Tcl script to generate the sqlite.html file. # set rcsid {$Id: c_interface.tcl,v 1.4 2000/06/06 18:24:42 drh Exp $} puts {<html> <head> <title>The C language interface to the SQLite library</title> </head> <body bgcolor=white> <h1 align=center> |
︙ | ︙ | |||
126 127 128 129 130 131 132 | </pre></blockquote> <p>The first argument to the callback is just a copy of the fourth argument to <b>sqlite_exec()</b> This parameter can be used to pass arbitrary information through to the callback function from client code. The second argument is the number columns in the query result. The third argument is an array of pointers to strings where each string | | > > > > > > > > > > | | 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 | </pre></blockquote> <p>The first argument to the callback is just a copy of the fourth argument to <b>sqlite_exec()</b> This parameter can be used to pass arbitrary information through to the callback function from client code. The second argument is the number columns in the query result. The third argument is an array of pointers to strings where each string is a single column of the result for that record. Note that the callback function reports a NULL value in the database as a NULL pointer, which is very different from an empty string. If the i-th parameter is an empty string, we will get:</p> <blockquote><pre> argv[i][0] == 0 </pre></blockquote> <p>But if the i-th parameter is NULL we will get:</p> <blockquote><pre> argv[i] == 0 </pre></blockquote> <p>The names of the columns are contained in the fourth argument.</p> <p>The callback function should normally return 0. If the callback function returns non-zero, the query is immediately aborted and <b>sqlite_exec()</b> will return SQLITE_ABORT.</p> <h2>Testing for a complete SQL statement</h2> |
︙ | ︙ |
Changes to www/changes.tcl.
︙ | ︙ | |||
12 13 14 15 16 17 18 19 20 21 22 23 24 25 | } proc chng {date desc} { puts "<DT><B>$date</B></DT>" puts "<DD><P><UL>$desc</UL></P></DD>" } chng {2000 June 3} { <li>Added support for default values on columns of a table.</li> <li>Improved test coverage. Fixed a few obscure bugs found by the improved tests.</li> } | > > > > > > > > | 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | } proc chng {date desc} { puts "<DT><B>$date</B></DT>" puts "<DD><P><UL>$desc</UL></P></DD>" } chng {2000 June 6} { <li>Added support for using <b>(SELECT ...)</b> within expressions</li> <li>Added support for <b>IN</b> and <b>BETWEEN</b> operators</li> <li>Added support for <b>GROUP BY</b> and <b>HAVING</b></li> <li>NULL values are now reported ot the callback as a NULL pointer rather than an empty string.</li> } chng {2000 June 3} { <li>Added support for default values on columns of a table.</li> <li>Improved test coverage. Fixed a few obscure bugs found by the improved tests.</li> } |
︙ | ︙ |
Changes to www/index.tcl.
1 2 3 | # # Run this TCL script to generate HTML for the index.html file. # | | > | | < > > > | < < < < | | | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 | # # Run this TCL script to generate HTML for the index.html file. # set rcsid {$Id: index.tcl,v 1.13 2000/06/06 18:24:42 drh Exp $} puts {<html> <head><title>SQLite: An SQL Database Built Atop GDBM</title></head> <body bgcolor=white> <h1 align=center>SQLite: An SQL Database Built Upon <a href="http://www.gnu.org/software/gdbm/gdbm.html">GDBM</a></h1> <p align=center>} puts "This page was last modified on [lrange $rcsid 3 4] GMT<br>" puts "The SQLite source code was last modifed on [exec cat last_change] GMT" puts {</p>} puts { <h2>News</h2> <p> The SQLite code base is being called "beta" only because it is relatively new. It appears to be stable and usable. Most of the SQL language is now implemented and working. The regression test suite provides good coverage, according to <a href="http://gcc.gnu.org/onlinedocs/gcov_1.html">gcov</a>. There are currently no known errors in the code.</p> <p>If you find bugs or missing features, please submit a comment to the <a href="#mailinglist">SQLite mailing list</a>.</p> } puts {<h2>Introduction</h2> <p>SQLite is an SQL database built atop the <a href="http://www.gnu.org/software/gdbm/gdbm.html">GDBM library</a>. The SQLite distribution includes both a interactive command-line |
︙ | ︙ | |||
54 55 56 57 58 59 60 | can be used as an example of how to interact with the SQLite C library. For more information on the sqlite program, see <a href="sqlite.html">sqlite.html</a>.</p> <p>A history of changes to SQLite is found <a href="changes.html">here</a>.</p> | | < < | | > | < | | > | | < | 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 | can be used as an example of how to interact with the SQLite C library. For more information on the sqlite program, see <a href="sqlite.html">sqlite.html</a>.</p> <p>A history of changes to SQLite is found <a href="changes.html">here</a>.</p> <p>SQLite now implements most of the SQL language. The following are the known limitations:</p> <p> <ul> <li>The UNION, INTERSECTION and EXCEPT operations connecting multiple SELECT statements are not yet implement</li> <li>Constraints are parsed but are not enforced</li> <li>There is not support for transactions or rollback</li> </ul> </p> <H2>Status</h2> <p>New features are still being added to the SQLite code base. Nevertheless, the code appears to be stable and relatively bug-free. At least one large database has be loaded into SQLite and appears to work.</p> <p>SQLite has so far been tested only on RedHat 6.0 Linux. But we know of no reason why it will not work on any other Unix platform, or on Windows95/98/NT.</p> } puts { |
︙ | ︙ |