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

Reply via email to