Send data to a server in a loop

[ThePuiu]

Need to submit multiple records of a table to a SQL server. Transmission is made record with recored in a "for" loop. I need the best solution to do that. I try something like that:

For i=0 to N
if READY
URL = "........"
HttpUtils.PostString("Job1", URL, "")
Else
Do While Not READY
Loop
End If
Next
........
Sub JobDone (Job As String)
....
READY = true
End Sub

but always send only the first record.

TY!

 

[Erel]

1. Such loops do not work. The message queue cannot be processed so the program will hang.
2. You should use HttpUtils2 instead of HttpUtils.

3. Put a counter in JobDone and when all jobs complete continue the program flow.