Sub GetNotSent
Dim req As DBRequestManager = CreateRequest
Dim cmd As DBCommand = CreateCommand("select_notsent", Array())
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
MyID = res.Columns.Get("id")
MyCity = res.Columns.Get("city")
MyProduct1 = res.Columns.Get("product1")
req.PrintTable(res)
Log("ID: " & MyID)
Log("City: " & MyCity)
Log("Product: " & MyProduct1)
Else
Log("ERROR: " & j.ErrorMessage)
End If
j.Release
End Sub