C
cedmunds
Group:
We have an application that is calling a stored proc. The stored proc
takes anywhere from 15 to 90 minutes to run.
In order to keep the GUI responsive, we are using a BackgroundWorker to
actually make the call to the stored proc. The app then sits in a loop
that awakes every second and updates an elapsed time value.
The problem that we are having is that after a certain period of time -
which is rarely the same amount - the call to DoEvents hangs (does not
return).
I was hoping the group could help us with: a) why thiat might be
occuring and b) what if anything can be done to fix it.
Here's the key areas of the code:
This is from the method that starts the ball rolling:
We have an application that is calling a stored proc. The stored proc
takes anywhere from 15 to 90 minutes to run.
In order to keep the GUI responsive, we are using a BackgroundWorker to
actually make the call to the stored proc. The app then sits in a loop
that awakes every second and updates an elapsed time value.
The problem that we are having is that after a certain period of time -
which is rarely the same amount - the call to DoEvents hangs (does not
return).
I was hoping the group could help us with: a) why thiat might be
occuring and b) what if anything can be done to fix it.
Here's the key areas of the code:
This is from the method that starts the ball rolling: