Sub GetPhotos As StringBuilder
Dim dbList As List:dbList.Initialize:dbList=DBUtils.ExecuteMemoryTable2(Memory.dbdb,"SELECT rowid,JobNumber,EmpSubCode,PhotoID,PhotoDateTime,PhotoType,PhotoDescription,Synced FROM PHOTOS WHERE PhotoID='New' AND (Synced<>'Y' OR Synced IS NULL)",Null,0)
Dim PostData As StringBuilder:PostData.Initialize
If dbList.Size<>0 Then
For RecNo = 0 To 0
Dim Record As Map:Record.Initialize:Record=dbList.Get(RecNo)
Dim RecordText As StringBuilder:RecordText.Initialize
RecordText.Append("PHOTOS"&Chr(352)&Record.Get("rowid")&Chr(352)) 'RECORD TYPE AND ID
RecordText.Append(Record.Get("JobNumber")&Chr(352)) ' JOB NUMBER
RecordText.Append(Record.Get("EmpSubCode")&Chr(352)) ' empsub
RecordText.Append(Record.Get("PhotoDateTime")&Chr(352)) ' Date/Time
RecordText.Append(Record.Get("PhotoType")&Chr(352)) ' Type
RecordText.Append(Record.Get("PhotoDescription")&Chr(352)) ' Description
RecordText.Append(Common.EncodeBase64(Common.loadImageFromBlob(Memory.dbdb, "PHOTOS", "PhotoBlob", Record.Get("rowid"))))
PostData.Append(RecordText.ToString.Replace(Chr(10),Chr(26))&Chr(10))
If RecNo Mod 20 =0 Then DoEvents
'If RecordText.Length>5*1024*1024 Then RecNo=50
Next
Return PostData