Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Clarification on the operation of the xUpdate method in the virtual table interface. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA3-256: |
ecec1e668bd62c0dc79960b8fab45a64 |
| User & Date: | drh 2017-08-09 20:03:17 |
Context
|
2017-08-11
| ||
| 00:54 | Fix a typo in the fileformat document check-in: 85bec545b9 user: drh tags: trunk | |
|
2017-08-09
| ||
| 20:03 | Clarification on the operation of the xUpdate method in the virtual table interface. check-in: ecec1e668b user: drh tags: trunk | |
|
2017-08-08
| ||
| 03:33 | In the 35%-faster report, invert the ratios on the charts, as this seems to make them easier to understand. Check-in the spreadsheet used to construct the charts. check-in: 4869b508d9 user: drh tags: trunk | |
Changes
Changes to pages/vtab.in.
1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 |
<p>Each call to xUpdate will fall into one of cases shown below.
Not that references to <b>argv[i]</b> mean the SQL value
held within the argv[i] object, not the argv[i]
object itself.
<blockquote>
<dl>
<dt><b>argc = 1</b>
<dd><p>The single row with rowid equal to argv[0] is deleted. No insert occurs.
<dt><b>argc > 1 <br> argv[0] = NULL</b>
<dd><p>A new row is inserted with a rowid argv[1] and column values in
argv[2] and following. If argv[1] is an SQL NULL,
the a new unique rowid is generated automatically.
|
| |
1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 |
<p>Each call to xUpdate will fall into one of cases shown below.
Not that references to <b>argv[i]</b> mean the SQL value
held within the argv[i] object, not the argv[i]
object itself.
<blockquote>
<dl>
<dt><b>argc = 1 <br> argv[0] ≠ NULL</b>
<dd><p>The single row with rowid equal to argv[0] is deleted. No insert occurs.
<dt><b>argc > 1 <br> argv[0] = NULL</b>
<dd><p>A new row is inserted with a rowid argv[1] and column values in
argv[2] and following. If argv[1] is an SQL NULL,
the a new unique rowid is generated automatically.
|