Android Question update sql string

Makumbi said:

i have written this small code my it does not update my table as i required

i wanted the phone number to be update by the newphone and the code to also be updated to the new code but when i check i dont see any changes to my table please help

B4X:

Dim sqlString As String
                sqlString ="UPDATE Register SET Phone = ?, code = ? Where Phone = ? AND code = ?"
                cursor1 =Starter.SQL1.ExecQuery2(sqlString ,Array As String(Newnumber.Text, Codenewn.Text,Oldn.Text,Codeolda.Text))

Click to expand...

    Dim sqlString As String
    sqlString ="UPDATE Register SET Phone = ?, code = ? Where Phone = ? AND code = ?"
    Starter.SQL1.ExecNonQuery2(sqlString ,Array As String(Newnumber.Text, Codenewn.Text,Oldn.Text,Codeolda.Text))