Hello guys, can you help me to create a progress bar in order to know the status of the sql insert statement?
I've already tried to add a progress bar referring to variables "ì" or "j" in the While statements to execute PerformStep() and invoke Application.DoEvents() for a
Thread.Sleep(40) using the MOD, but whenever I put something after the While instructions, the entire code execution is impacted, taking more than 1 hour to generate the insert?!?!?
I've already tried to add a progress bar referring to variables "ì" or "j" in the While statements to execute PerformStep() and invoke Application.DoEvents() for a
Thread.Sleep(40) using the MOD, but whenever I put something after the While instructions, the entire code execution is impacted, taking more than 1 hour to generate the insert?!?!?
my example code:
.
...()
LstWork = DSO.query("select distinct (workers...
While LstWork.AtEnd = False
j = 1
FuncList = DSO.Query(";with EffectiveYears as (...
i = 1
While ListFunc.NoFim = False
field1 = ListFunc.x
field2 = ListFunc.y
field3 = ListFunc.z
TSO.ExecuteSQL ( INSERT INTO [dbo].[TBL_Work] ( ColMov1, ColMov2 , ColMov3 ) Values ( " & " Field1 & ", " & " Field2 & "," & " Field3 & ")" )
i += 1
ListFunc.Next()
End While
j += 1
LstWork.Next()
End While
End Sub