Insert empty BLOB into SQLite DB using ODBC and C++ Net

Question

I'm using a SQLite database to store cover images of books I have in a database. I've got the inserting of BLOBs ok, but when I don't have a cover image for my book I can't seem to get it to insert a null BLOB.

I'm using parameters for my insert SQL statement, using ODBC, as shown below:

OdbcParameter^ paramCoverImage = gcnew OdbcParameter("@CoverImage", ByteArray);

cmd->Parameters->Add(paramCoverImage);

But when I try and do it with nullptr instead of the ByteArray, SQLite gives an error. I want to use the SQL NULL, but I can't find out how to do that using ODBC and SQLite. Any ideas?

Robin

Reed Copsey · Accepted Answer · 2009-06-03 17:39:16Z

3

Try:

OdbcParameter^ paramCoverImage = gcnew OdbcParameter("@CoverImage", OdbcType::Binary);
paramCoverImage->Value = System::DbNull->Value;

answered Jun 3, 2009 at 17:39

Reed Copsey

567k80 gold badges1.2k silver badges1.4k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert empty BLOB into SQLite DB using ODBC and C++ Net

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related