Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Mention the -withoutnulls option to the "db eval" method in the TCL interface documentation. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
b1785f3962a546b232815b5d32c9a7fe |
User & Date: | drh 2017-06-29 18:27:42.280 |
Context
2017-06-29
| ||
20:54 | Update the speed-size graph spreadsheet (check-in: 8b7c30639e user: drh tags: trunk) | |
18:27 | Mention the -withoutnulls option to the "db eval" method in the TCL interface documentation. (check-in: b1785f3962 user: drh tags: trunk) | |
18:17 | Add documentation for the STMT virtual table (check-in: 3c1197562c user: drh tags: trunk) | |
Changes
Changes to pages/tclsqlite.in.
︙ | ︙ | |||
174 175 176 177 178 179 180 | METHOD eval { <p> The most useful <i>dbcmd</i> method is "eval". The eval method is used to execute SQL on the database. The syntax of the eval method looks like this:</p> <blockquote> | | | 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 | METHOD eval { <p> The most useful <i>dbcmd</i> method is "eval". The eval method is used to execute SQL on the database. The syntax of the eval method looks like this:</p> <blockquote> <i>dbcmd</i> <b>eval</b> ?<i>options</i>? <i>sql</i> ?<i>array-name</i>? ?<i>script</i>? </blockquote> <p> The job of the eval method is to execute the SQL statement or statements given in the second argument. For example, to create a new table in a database, you can do this:</p> |
︙ | ︙ | |||
247 248 249 250 251 252 253 254 255 256 257 258 259 260 | in the corresponding array entry. (Caution: If two or more columns in the result set of a query have the same name, then the last column with that name will overwrite prior values and earlier columns with the same name will be inaccessible.) The special array index * is used to store a list of column names in the order that they appear. </p> <p> If the array variable name is omitted or is the empty string, then the value of each column is stored in a variable with the same name as the column itself. For example: </p> <blockquote> | > > > > > > > | 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 | in the corresponding array entry. (Caution: If two or more columns in the result set of a query have the same name, then the last column with that name will overwrite prior values and earlier columns with the same name will be inaccessible.) The special array index * is used to store a list of column names in the order that they appear. </p> <p> Normally, NULL SQL results are stored in the array using the <a href="#nullvalue">nullvalue</a> setting. However, if the <b>-withoutnulls</b> option is used, then NULL SQL values cause the corresponding array element to be unset instead. </p> <p> If the array variable name is omitted or is the empty string, then the value of each column is stored in a variable with the same name as the column itself. For example: </p> <blockquote> |
︙ | ︙ |