Android Question SQL Update command

[mscientist33]

I can't find an example of an SQL statement using the "UPDATE" command. This is the page I'm use to using to go by: B4A SQL

This is my current SQL:

mSQL.ExecNonQuery2("UPDATE " & cselectedversion  & " SET fav=? WHERE id=?", Array As String("1",p.GetView(2).Tag))

 

[Erel]

What happens when you run this code?

 

[klaus]

There is a small example in the B4X SQLite database booklet.

 

[mscientist33]

There is a small example in the B4X SQLite database booklet.

Problem solved. It was updating but someone pointed out that I was recopying the database at each start over writing the update.....