>*get shipments from SSS with the Arrival Id present >lnRetVal = SQLEXEC(lnConnHandle, "SELECT a.BillNr, a.ConfigCharEight, a.ScheduledShipDate, " + ; > "a.RecordDate, a.PreSpecCarrierId, b.ProNumber " + ; > "FROM tblShipmentHeader a JOIN tblLoad b " + ; > "ON a.BillNr = b.LoadId " + ; > "WHERE a.ConfigCharEight IS NOT NULL " + ; > "AND a.RecordDate > GETDATE() -6", "Results") > > > >*update Arrival dbf with the ship date and tracking number >UPDATE a ; >SET a.utext5 = b.ProNumber, ; > a.utext6 = CAST(b.ScheduledShipDate as char(30)) ; >FROM (lcArrivalFilePath) a JOIN Results b ; > ON a.pieceid = b.ConfigCharEight > >>