Originally posted by Clare Perry
I want to increment a progress bar whilst a sql update that takes around 30s is performed. As it's a sql update and I'm not looping through records, I can't increment during the update. I have tried having a function called with a do while loop incrementing every 3 seconds - which works, but it performs the function first and then performs the sql update - which makes the whole process nearly 2 mins rather than the 30 seconds. Any way of getting the progress bar to auto increment 1 every 3 seconds whilst the sql update is performing?? |