Krisalianne Member Licensed User Longtime User Feb 26, 2014 #1 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 ...
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 ...
M Mahares Expert Licensed User Longtime User Feb 26, 2014 #2 Code: Copy 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 Upvote 0
Code: Copy 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
