Android Question How to pass parameter to update table

[Makumbi]

Please help on how to pass these controls to my table

Codeolda.Text = "" Or Codenewn.Text = "" Or Oldn.Text = "" Or Newnumber.Text = ""
my table to be updated is below
Update Androidregistration set Phone=@newnumber,codes=@codenew WHERE Phone = @oldnumber and codes=@codeold"

 

[Jeffrey Cameron]

You should watch @Erel's video: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/

 

[Makumbi]

You should watch @Erel's video: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/

I have checked but it has one parameter passed it doesnot have multiple parameters.

 

[DonManfred]

I have checked but it has one parameter passed it doesnot have multiple parameters.

This is a code from the example from the tutorial.

    sql.ExecNonQuery2("UPDATE students SET image = ? WHERE id = ?", Array(b, 10))