Android Question UPDATE database

[Basco]

Hi,
I'm trying to update my database. I am using this statement but my application crashes when performing this statement.
I don't really know how to use UPDATE SQLite statement.
Here is my sub :

Sub Button1f_Click

dbsql.ExecNonQuery2("UPDATE Plateforme ('AnneeAchat','PrixAchat','Commentaire') VALUES (?,?,?) WHERE Modele = ? ", Array As String(EditText1f.Text, EditText2f.Text, EditText3f.Text, Spinner1f.SelectedItem))
dbcursor.close
Msgbox("modifications enregistrées sur " & Spinner1f.SelectedItem,"")​

End Sub

What could be wrong ?

Thank you for your time !

 

[giga]

Did you use the DBUtils class with DBUtils.UpdateRecord ?

 

[Mahares]

Here is the code you need if you are not using DBUtils that Giga is referring to:

dbsql.ExecNonQuery2("UPDATE Plateforme SET AnneeAchat =?,PrixAchat =?, " _
& "Commentaire =? WHERE Modele = ? ", _
Array As Object(EditText1f.Text, EditText2f.Text, EditText3f.Text, Spinner1f.SelectedItem))
Msgbox("modifications enregistrées sur " & Spinner1f.SelectedItem,"")

Bonne Chance

 

[mangojack]

Basco .. if you have not already seen these , they will be helpful and contain an example of your Update statement.

two simple SQLite Examples by Klaus ...

 

[Basco]

Thanks to all of you for your answers.
Your code works great Mahares ! (I had no doubt !)
I'll improve my skills with yours advices, thanks