public Sub GetMessagesSent
DateTime.DateFormat = "dd-MMM-yy"
Dim req As DBRequestManager = CreateRequest
Dim cmd As DBcommand = CreateCommand("showsentmessages", Array(AndroidID))
Dim ColWidths(5) As Int
Table1.ClearAll
Table1.SetHeader(Array As String("Date","Message","Remarks","Solved","ID"))
ColWidths(0)=55dip
ColWidths(1)=260dip
ColWidths(2)=0dip
ColWidths(3)=0dip
ColWidths(4)=50dip
Table1.SetColumnsWidths(ColWidths)
Table1.RowHeight=60dip
Table1.SingleLine = False
Wait For (req.ExecuteQuery(cmd, 0, AndroidID)) JobDone(j As HttpJob)
If j.Success Then
req.HandleJobAsync(j, "req")
Wait For (req) req_Result(res As DBresult)
Dim Alignments(5) As Int
Alignments = Array As Int(Bit.Or(Gravity.LEFT, Gravity.CENTER_VERTICAL), Bit.Or(Gravity.LEFT, Gravity.CENTER_VERTICAL), Bit.Or(Gravity.LEFT, Gravity.CENTER_VERTICAL), Bit.Or(Gravity.CENTER, Gravity.CENTER_VERTICAL), Bit.Or(Gravity.CENTER, Gravity.CENTER_VERTICAL))
Table1.SetCellAlignments(Alignments)
If res.Rows.Size > 0 Then
'Dim Row(5) As String
For i = 1 To res.Rows.Size-1
Dim Row() As Object =Array(res.Columns.Get(0),res.Columns.Get(1) & Chr(10) & "Reply: " & res.Columns.Get(2),res.Columns.Get(2),res.Columns.Get(3),res.Columns.Get(4)) ' = Array("DateTime","Message","Remark","Resolved","ID")
Table1.addRow(Row)
Next
pnlTables.Visible = True
Else
lblMessage.text = "No messages sent to office were fetched."
pnlTables.Visible = False
Table1.visible = False
End If
Else
Log("ERROR: " & j.ErrorMessage)
End If
j.release
CallSubDelayed(Me, "resGetMessagesSent_Complete")
End Sub