SQLite Insert/Update BLOB at specific position

Hi, the following code inserts a BLOB:

Code:

  SQL1.ExecNonQuery2("INSERT INTO table2 VALUES('smiley', ?)", Array As Object(Buffer))  

However, I have a table that has 6 fields: id, img1, img2, img3, img4, img5

How can I insert the BLOB into a specific field, say "img3"?
Also, what would the syntax be to UPDATE / SET a BLOB in a specific field?

My code is:

Code:

  Dim InputStream1 As InputStream
    InputStream1 = File.OpenInput(File.DirAssets, "yelloe icone empty - copy.png")
Dim...  

SQLite Insert/Update BLOB at specific position

from B4X Community - Android, iOS, desktop, server and IoT programming tools http://ift.tt/2bLsl7S
via IFTTT