Android Question How to UPDATE values in database by sending a Parameter?

[Pravee7094]

I searched example for UPDATE query in b4x forum but I got only hardcoded UPDATE command.

for example:

Dim ID As Int
ID = 2
Dim req As DBRequestManager = CreateRequest
          Dim cmd As DBCommand = CreateCommand("UPDATE_table", Array (edtName.Text,edtLastName.Text,ID))
            Dim j As HttpJob = CreateRequest.ExecuteBatch(Array(cmd), Null)
            Wait For (req.ExecuteCommand(cmd,Null)) JobDone(j As HttpJob)
            If j.Success Then
                Log("Update Successefull")
            Else
                Log("ERROR Update" & j.ErrorMessage)
            End If
            j.Release

But I want to send that ID as a parameter
Help!

Regards
Praveen

 

[Erel]

Question is unclear. Are you using jRDC2?

 

[Pravee7094]

Question is unclear. Are you using jRDC2?

Yes sir I am using JRDC2

 

[Erel]

Create a command:

sql.update=UPDATE table SET column = ? WHERE id = ?

Now send a command with two parameters.