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. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
b1785f3962a546b232815b5d32c9a7fe |
| User & Date: | drh 2017-06-29 18:27:42 |
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
181
182
183
184
185
186
187
188
...
247
248
249
250
251
252
253
254
255
256
257
258
259
260
|
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>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>
................................................................................
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>
|
|
>
>
>
>
>
>
>
|
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
...
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
|
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>
................................................................................
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>
|