Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Documentation changes only (CVS 151) |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
15340d2bb34c4d7ab629f9fa2231c7f3 |
User & Date: | drh 2000-10-09 12:57:01.000 |
Context
2000-10-09
| ||
22:30 | Version 1.0.9 (CVS 493) (check-in: ebbb9e4a66 user: drh tags: trunk) | |
12:57 | Documentation changes only (CVS 151) (check-in: 15340d2bb3 user: drh tags: trunk) | |
2000-10-08
| ||
22:20 | Added the _printf() interface. (CVS 150) (check-in: f9372072a6 user: drh tags: trunk) | |
Changes
Changes to src/sqlite.h.in.
︙ | ︙ | |||
20 21 22 23 24 25 26 | ** drh@hwaci.com ** http://www.hwaci.com/drh/ ** ************************************************************************* ** This header file defines the interface that the sqlite library ** presents to client programs. ** | | | 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 | ** drh@hwaci.com ** http://www.hwaci.com/drh/ ** ************************************************************************* ** This header file defines the interface that the sqlite library ** presents to client programs. ** ** @(#) $Id: sqlite.h.in,v 1.5 2000/10/09 12:57:01 drh Exp $ */ #ifndef _SQLITE_H_ #define _SQLITE_H_ #include <stdarg.h> /* Needed for the definition of va_list */ /* ** The version of the SQLite library. |
︙ | ︙ | |||
123 124 125 126 127 128 129 | char *sql, /* SQL to be executed */ sqlite_callback, /* Callback function */ void *, /* 1st argument to callback function */ char **errmsg /* Error msg written here */ ); /* | | | 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 | char *sql, /* SQL to be executed */ sqlite_callback, /* Callback function */ void *, /* 1st argument to callback function */ char **errmsg /* Error msg written here */ ); /* ** Return values for sqlite_exec() */ #define SQLITE_OK 0 /* Successful result */ #define SQLITE_INTERNAL 1 /* An internal logic error in SQLite */ #define SQLITE_ERROR 2 /* SQL error or missing database */ #define SQLITE_PERM 3 /* Access permission denied */ #define SQLITE_ABORT 4 /* Callback routine requested an abort */ #define SQLITE_BUSY 5 /* One or more database files are locked */ |
︙ | ︙ | |||
195 196 197 198 199 200 201 | ** Name | Age ** ----------------------- ** Alice | 43 ** Bob | 28 ** Cindy | 21 ** ** If the 3rd argument were &azResult then after the function returns | | | 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 | ** Name | Age ** ----------------------- ** Alice | 43 ** Bob | 28 ** Cindy | 21 ** ** If the 3rd argument were &azResult then after the function returns ** azResult will contain the following data: ** ** azResult[0] = "Name"; ** azResult[1] = "Age"; ** azResult[2] = "Alice"; ** azResult[3] = "43"; ** azResult[4] = "Bob"; ** azResult[5] = "28"; |
︙ | ︙ | |||
236 237 238 239 240 241 242 | /* ** Call this routine to free the memory that sqlite_get_table() allocated. */ void sqlite_free_table(char **result); /* ** The following routines are wrappers around sqlite_exec() and | | | 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 | /* ** Call this routine to free the memory that sqlite_get_table() allocated. */ void sqlite_free_table(char **result); /* ** The following routines are wrappers around sqlite_exec() and ** sqlite_get_table(). The only difference between the routines that ** follow and the originals is that the second argument to the ** routines that follow is really a printf()-style format ** string describing the SQL to be executed. Arguments to the format ** string appear at the end of the argument list. ** ** All of the usual printf formatting options apply. In addition, there ** is a "%q" option. %q works like %s in that it substitutes a null-terminated |
︙ | ︙ |
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.10 2000/10/09 12:57:01 drh Exp $} puts {<html> <head> <title>The C language interface to the SQLite library</title> </head> <body bgcolor=white> <h1 align=center> |
︙ | ︙ | |||
315 316 317 318 319 320 321 | to <b>sqlite_free_table()</b> when the table is no longer needed.</p> <p>The <b>sqlite_get_table()</b> routine returns the same integer result code as <b>sqlite_exec()</b>.</p> <h2>Testing for a complete SQL statement</h2> | | | 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 | to <b>sqlite_free_table()</b> when the table is no longer needed.</p> <p>The <b>sqlite_get_table()</b> routine returns the same integer result code as <b>sqlite_exec()</b>.</p> <h2>Testing for a complete SQL statement</h2> <p>The next interface routine to SQLite is a convenience function used to test whether or not a string forms a complete SQL statement. If the <b>sqlite_complete()</b> function returns true when its input is a string, then the argument forms a complete SQL statement. There are no guarantees that the syntax of that statement is correct, but we at least know the statement is complete. If <b>sqlite_complete()</b> returns false, then more text is required to complete the SQL statement.</p> |
︙ | ︙ | |||
428 429 430 431 432 433 434 | substituted string. This has the effect of escaping the end-of-string meaning of single-quote within a string literal. </p> <p>Consider an example. Suppose you are trying to insert a string values into a database table where the string value was obtained from user input. Suppose the string to be inserted is stored in a variable | | | 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 | substituted string. This has the effect of escaping the end-of-string meaning of single-quote within a string literal. </p> <p>Consider an example. Suppose you are trying to insert a string values into a database table where the string value was obtained from user input. Suppose the string to be inserted is stored in a variable named zString. The code to do the insertion might look like this:</p> <blockquote><pre> sqlite_exec_printf(db, "INSERT INTO table1 VALUES('%s')", 0, 0, 0, zString); </pre></blockquote> |
︙ | ︙ |
Changes to www/changes.tcl.
︙ | ︙ | |||
27 28 29 30 31 32 33 | chng {2000 Sep 30 (1.0.8)} { <li>Begin writing documentation on the TCL interface.</li> } chng {2000 Sep 29 (Not Released)} { <li>Added the <b>sqlite_get_table()</b> API</li> | | | 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | chng {2000 Sep 30 (1.0.8)} { <li>Begin writing documentation on the TCL interface.</li> } chng {2000 Sep 29 (Not Released)} { <li>Added the <b>sqlite_get_table()</b> API</li> <li>Updated the documentation for due to the above change.</li> <li>Modified the <b>sqlite</b> shell to make use of the new sqlite_get_table() API in order to print a list of tables in multiple columns, similar to the way "ls" prints filenames.</li> <li>Modified the <b>sqlite</b> shell to print a semicolon at the end of each CREATE statement in the output of the ".schema" command.</li> } |
︙ | ︙ |