M Makumbi Well-Known Member Licensed User Longtime User Dec 4, 2018 #1 Please help on how to pass these controls to my table Code: 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" Last edited: Dec 4, 2018
Please help on how to pass these controls to my table Code: 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 Well-Known Member Licensed User Longtime User Dec 4, 2018 #2 You should watch @Erel's video: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/ Upvote 0
M Makumbi Well-Known Member Licensed User Longtime User Dec 4, 2018 #3 Jeffrey Cameron said: You should watch @Erel's video: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/ Click to expand... I have checked but it has one parameter passed it doesnot have multiple parameters. Upvote 0
Jeffrey Cameron said: You should watch @Erel's video: https://www.b4x.com/android/forum/threads/sql-tutorial.6736/ Click to expand... I have checked but it has one parameter passed it doesnot have multiple parameters.
DonManfred Expert Licensed User Longtime User Dec 4, 2018 #4 Makumbi said: I have checked but it has one parameter passed it doesnot have multiple parameters. Click to expand... This is a code from the example from the tutorial. Code: sql.ExecNonQuery2("UPDATE students SET image = ? WHERE id = ?", Array(b, 10)) Last edited: Dec 5, 2018 Upvote 0
Makumbi said: I have checked but it has one parameter passed it doesnot have multiple parameters. Click to expand... This is a code from the example from the tutorial. Code: sql.ExecNonQuery2("UPDATE students SET image = ? WHERE id = ?", Array(b, 10))
