ThePuiu Active Member Licensed User Longtime User Feb 20, 2013 #1 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: Code: Copy 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!
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: Code: Copy 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 B4X founder Staff member Licensed User Longtime User Feb 21, 2013 #2 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. Upvote 0
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.
