Android Question String and Image to store in a SQL DB

[Krisalianne]

Hello everybody,
I have a question regarding saving string and image in a SQL Db.
For now I have the following code :
SQL1.ExecNonQuery2("INSERT INTO table1 VALUES(?, ?, ?, 0)" ,Array As String(ch1, ch2, ch3))

Now I would like to add an image in the forth colum which is image field.

But how to mix string and image ?

Thank you in advance ...

 

[Mahares]

SQL1.ExecNonQuery2("INSERT INTO table1 VALUES(?, ?, ?, ?)" ,Array As Object(ch1, ch2, ch3, Buffer))

Here is a very nice complete project by Mangojack that illustrates how to do it:
http://www.b4x.com/android/forum/threads/sqllite-and-images.37645/#post-222259

 

[Krisalianne]

Many Thanks Mahares