How to update a BLOB field

[Der Mond]

I read the SQLITE tutorial but I have not found how to update a BLOB field.
Is it possible?

Thanks to all

 

[Erel]

Yes, you can change the following statement to an UPDATE statement:

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

 

[Der Mond]

Thank a lot Erel

 

[Firpas]

But ....

It is not a update. It is a Insert. Is necesary to delete before. isn't it?

How to update directly?

 

[Erel]

Please start a new thread for this question. This is a very old thread.