Documentation Source Text

Check-in [ecec1e668b]
Login

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: ecec1e668bd62c0dc79960b8fab45a6435c5c1c12716c871d0fcbdb979408170
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
Hide Diffs Unified Diffs Ignore Whitespace Patch

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&#91;i&#93</b> mean the SQL value
held within the argv&#91;i&#93; object, not the argv&#91;i&#93;
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 &gt; 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&#91;i&#93</b> mean the SQL value
held within the argv&#91;i&#93; object, not the argv&#91;i&#93;
object itself.

<blockquote>
<dl>
<dt><b>argc = 1 <br> argv[0] &ne; NULL</b>
<dd><p>The single row with rowid equal to argv[0] is deleted. No insert occurs.

<dt><b>argc &gt; 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.