Hi everyone.
I try to retrieve some blob images from my server side using JRDC2. Not many just 18000...
The problem is that every time I try I get time out error.. if i filter my records for example top 100 then everything working fine.
Any idea how I can skip this time out error?
The code I use in B4A is
The error I get is
Any help how to solve it?
I try to retrieve some blob images from my server side using JRDC2. Not many just 18000...
The problem is that every time I try I get time out error.. if i filter my records for example top 100 then everything working fine.
Any idea how I can skip this time out error?
The code I use in B4A is
B4X:
Sub ESFIItemBlob_ReplaseInto(Dt1 As String, FStart As Boolean) As ResumableSub
Dim AllDone As Boolean
Dim i As Int = 1
Dim req As DBRequestManager = CreateRequest
Dim cmd As DBCommand = CreateCommand("Select_ESitemBlob_ReplaseInto", Array(Dt1, Dt1))
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
'req.PrintTable(res)
For Each row() As Object In res.Rows
Dim b() As Byte = row(res.Columns.Get("TS"))
Dim bc As ByteConverter
' Log(bc.HexFromBytes(b))
Starter.LocalSQL.ExecNonQuery2($"REPLACE INTO LOCAL_Blob (Item_Code, IItem_GID, BlobData, BlobSize, TS)
VALUES (?, ?, ?, ?, ?)"$, Array As Object(row(1), row(2), row(3), row(4), bc.HexFromBytes(b)))
Next
AllDone = True
Else
Log("ERROR: " & j.ErrorMessage)
AllDone = False
End If
j.Release
Return AllDone
End SubThe error I get is
Any help how to solve it?