'SQLite: Reading a blob from a table that has no rowid

I'm using the C SQLite library.

I need to obtain the value of a blob from a row. The row is in a table that does not have any row id.

This causes sqlite3_blob_open to return an error - that rowid is not present in the table.

Software like DB Browser for SQLite is able to query the value of these blobs, so there must be a way to do it.

c++c database sqlite

Solution 1:^[1]

The answer is to use sqlite3_step() in conjunction with sqlite3_column_blob()

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source
Solution 1	Frank Zyna