On Jan 26, 2010, at 4:15 PM, cp wrote: > I'd like to be able to append some data to a binary field (BLOB) > without reading the original data, concatenating it, and then setting > it all back. Is this possible?
Append is not possible. But if you preallocate space using zeroblob() or similar, you can write to it using the incremental blob API: http://www.sqlite.org/c3ref/blob_open.html > > If matters, I want to append pictures to a field, probably using a > struct like > > struct { > int pic_type, > int pic_size, > byte* pic_data > } > > thanks in advance > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users