1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
3
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
4
<title>Write Data Into A BLOB Incrementally</title>
5
<style type="text/css">
8
font-family: Verdana, sans-serif;
13
a:visited { color: #734559 }
15
.logo { position:absolute; margin:3px; }
31
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
32
.toolbar a:visited { color: white; }
33
.toolbar a:hover { color: #044a64; background: white; }
35
.content { margin: 5%; }
36
.content dt { font-weight:bold; }
37
.content dd { margin-bottom: 25px; margin-left:20%; }
38
.content ul { padding:0px; padding-left: 15px; margin:0px; }
41
.se { background: url(../images/se.gif) 100% 100% no-repeat #044a64}
42
.sw { background: url(../images/sw.gif) 0% 100% no-repeat }
43
.ne { background: url(../images/ne.gif) 100% 0% no-repeat }
44
.nw { background: url(../images/nw.gif) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy img+p {font-style:italic}
48
.fancy .codeblock i { color: darkblue; }
49
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
50
.fancy h2 { margin-left: 10px }
51
.fancy h3 { margin-left: 20px }
52
.fancy h4 { margin-left: 30px }
53
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
54
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
55
.fancy #toc a { color: darkblue ; text-decoration: none }
56
.fancy .todo { color: #AA3333 ; font-style : italic }
57
.fancy .todo:before { content: 'TODO:' }
58
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
59
.fancy img { display:block; }
60
.fancy :link:hover, .fancy :visited:hover { background: wheat }
61
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
62
.fancy li p { margin: 1em 0 }
63
/* End of "fancyformat" specific rules. */
69
<div><!-- container div to satisfy validator -->
71
<a href="../index.html">
72
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite Logo"
74
<div><!-- IE hack to prevent disappearing logo--></div>
75
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
77
<table width=100% style="clear:both"><tr><td>
78
<div class="se"><div class="sw"><div class="ne"><div class="nw">
79
<table width=100% style="padding:0;margin:0;cell-spacing:0"><tr>
82
<a href="../about.html">About</a>
83
<a href="../sitemap.html">Sitemap</a>
84
<a href="../docs.html">Documentation</a>
85
<a href="../download.html">Download</a>
86
<a href="../copyright.html">License</a>
87
<a href="../news.html">News</a>
88
<a href="../support.html">Support</a>
91
gMsg = "Search SQLite Docs..."
92
function entersearch() {
93
var q = document.getElementById("q");
94
if( q.value == gMsg ) { q.value = "" }
95
q.style.color = "black"
96
q.style.fontStyle = "normal"
98
function leavesearch() {
99
var q = document.getElementById("q");
100
if( q.value == "" ) {
102
q.style.color = "#044a64"
103
q.style.fontStyle = "italic"
108
<div style="padding:0 1em 0px 0;white-space:nowrap">
109
<form name=f method="GET" action="http://www.sqlite.org/search">
110
<input id=q name=q type=text
111
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
112
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
116
</div></div></div></div>
118
<div class=startsearch></div>
120
<a href="intro.html"><h2>SQLite C Interface</h2></a><h2>Write Data Into A BLOB Incrementally</h2><blockquote><pre>int sqlite3_blob_write(sqlite3_blob *, const void *z, int n, int iOffset);
121
</pre></blockquote><p>
122
This function is used to write data into an open <a href="../c3ref/blob.html">BLOB handle</a> from a
123
caller-supplied buffer. N bytes of data are copied from the buffer Z
124
into the open BLOB, starting at offset iOffset.</p>
126
<p>If the <a href="../c3ref/blob.html">BLOB handle</a> passed as the first argument was not opened for
127
writing (the flags parameter to <a href="../c3ref/blob_open.html">sqlite3_blob_open()</a> was zero),
128
this function returns <a href="../c3ref/c_abort.html">SQLITE_READONLY</a>.</p>
130
<p>This function may only modify the contents of the BLOB; it is
131
not possible to increase the size of a BLOB using this API.
132
If offset iOffset is less than N bytes from the end of the BLOB,
133
<a href="../c3ref/c_abort.html">SQLITE_ERROR</a> is returned and no data is written. If N is
134
less than zero <a href="../c3ref/c_abort.html">SQLITE_ERROR</a> is returned and no data is written.
135
The size of the BLOB (and hence the maximum value of N+iOffset)
136
can be determined using the <a href="../c3ref/blob_bytes.html">sqlite3_blob_bytes()</a> interface.</p>
138
<p>An attempt to write to an expired <a href="../c3ref/blob.html">BLOB handle</a> fails with an
139
error code of <a href="../c3ref/c_abort.html">SQLITE_ABORT</a>. Writes to the BLOB that occurred
140
before the <a href="../c3ref/blob.html">BLOB handle</a> expired are not rolled back by the
141
expiration of the handle, though of course those changes might
142
have been overwritten by the statement that expired the BLOB handle
143
or by other independent statements.</p>
145
<p>On success, sqlite3_blob_write() returns SQLITE_OK.
146
Otherwise, an <a href="../c3ref/c_abort.html">error code</a> or an <a href="../c3ref/c_abort_rollback.html">extended error code</a> is returned.</p>
148
<p>This routine only works on a <a href="../c3ref/blob.html">BLOB handle</a> which has been created
149
by a prior successful call to <a href="../c3ref/blob_open.html">sqlite3_blob_open()</a> and which has not
150
been closed by <a href="../c3ref/blob_close.html">sqlite3_blob_close()</a>. Passing any other pointer in
151
to this routine results in undefined and probably undesirable behavior.</p>
153
<p>See also: <a href="../c3ref/blob_read.html">sqlite3_blob_read()</a>.
154
</p><p>See also lists of
155
<a href="objlist.html">Objects</a>,
156
<a href="constlist.html">Constants</a>, and
157
<a href="funclist.html">Functions</a>.</p>