[sqlite] How to use sqlite3_blob_open when the blob column is empty?

[Clemens Ladisch]

zhangkai wrote:
> insert into device(ieee) values(12345);

> int ret = sqlite3_blob_open(db,
>                 "main",
>                 "device",
>                 "endpoint",
>                 12345,
>                 1,
>                 &blob);

The documentation says:
| This function fails ... if any of the following are true:
| * The specified column of row iRow contains a value that is not a TEXT
|   or BLOB value

You have to replace the NULL value with an actual blob (even if it is
a blob of size zero) before you can use the incremental blob I/O
functions on it.


Regards,
Clemens