Der Mond Member Licensed User Longtime User Oct 12, 2011 #1 I read the SQLITE tutorial but I have not found how to update a BLOB field. Is it possible? Thanks to all
I read the SQLITE tutorial but I have not found how to update a BLOB field. Is it possible? Thanks to all
Erel B4X founder Staff member Licensed User Longtime User Oct 13, 2011 #2 Yes, you can change the following statement to an UPDATE statement: B4X: SQL1.ExecNonQuery2("INSERT INTO table2 VALUES('smiley', ?)", Array As Object(Buffer)) http://www.b4x.com/forum/basic4android-getting-started-tutorials/6736-sql-tutorial.html#post39108 Upvote 0
Yes, you can change the following statement to an UPDATE statement: B4X: SQL1.ExecNonQuery2("INSERT INTO table2 VALUES('smiley', ?)", Array As Object(Buffer)) http://www.b4x.com/forum/basic4android-getting-started-tutorials/6736-sql-tutorial.html#post39108
F Firpas Active Member Licensed User Longtime User Aug 17, 2013 #4 But .... It is not a update. It is a Insert. Is necesary to delete before. isn't it? How to update directly? Upvote 0
But .... It is not a update. It is a Insert. Is necesary to delete before. isn't it? How to update directly?
Erel B4X founder Staff member Licensed User Longtime User Aug 18, 2013 #5 Please start a new thread for this question. This is a very old thread. Upvote 0