Android Question sql.select_animal=SELECT name, image, id FROM animals WHERE id = ? and name =?

[guandjy]

Sub GetRecord (id As Int)
   Dim req As DBRequestManager = CreateRequest
   Dim cmd As DBCommand = CreateCommand("select_animal", Array(id))
   Wait For (req.ExecuteQuery(cmd, 0, Null)) JobDone(j As HttpJob)
   If j.Success Then
       req.HandleJobAsync(j, "req")
       Wait For (req) req_Result(res As DBResult)
       'work with result
       req.PrintTable(res)
   Else
       Log("ERROR: " & j.ErrorMessage)
   End If
   j.Release
End Sub

 

[jahswant]

What’s your question ?

 

[guandjy]

Thank you. It's settled. Just change it to this

Dim cmd As DBCommand = CreateCommand("select_denglu", Array(EditText1.text,EditText2.text))

 

[Mahares]

How to change to multi condition query:

The answer is is in the below thread post #2

[DBCommand] CreateCommand ...

#SQL COMMANDS sql.update_customers=UPDATE customers SET CustomerId = ?, FirstName = ?, LastName = ?, Company = ?, Address = ?, Email = ? WHERE rowid = ? Private Sub ShowDialog(Item As Map, RowId As Long, Action As Int) ... Dim params As List params.Initialize 'keys based...

www.b4x.com