Sub SetRouteList
Dim Routes As List
Routes = DBUtils.ExecuteMemoryTable(SQLLite, "SELECT rte_name FROM Routes", Null, 0)
For i = 0 To Routes.Size - 1
Dim route() As String
route = Routes.Get(i)
lvwRoutes.AddSingleLine(route(0))
Next
End Sub
Sub BuildLoadList As List
Dim AWBs As List
AWBs = DBUtils.ExecuteMemoryTable(SQLLite, "SELECT awb_number, cus_company, del_scancode FROM RunSheetDetails LEFT JOIN DeliveryHistory ON rnd_pk = del_rndfk AND del_scancode = 1 ORDER BY cus_company", Null, 0)
Return AWBs
End Sub
Sub BuildDeliveryList As List
Dim x As List
x = DBUtils.ExecuteMemoryTable(SQLLite, "SELECT DeliveryHistory.* FROM DeliveryHistory",Null,0)
Dim Deliveries As List
Deliveries = DBUtils.ExecuteMemoryTable(SQLLite, _
"SELECT awb_number, cus_company, DeliveryHistory.del_scancode, " _
& "DeliveryHistory.del_delivered " _
& ", cus_number " _
& "FROM DeliveryHistory " _
& "INNER JOIN (SELECT MAX(del_time) AS Latest, del_rndfk FROM DeliveryHistory GROUP BY del_rndfk) b " _
& "ON DeliveryHistory.del_rndfk = b.del_rndfk AND DeliveryHistory.del_time = b.Latest " _
& "INNER JOIN RunSheetDetails ON DeliveryHistory.del_rndfk = rnd_pk " _
& "ORDER BY DeliveryHistory.del_delivered, cus_company, awb_number " _
, Null, 0)
Return Deliveries
End Sub