I don't know if this works in run-time, but I know if there's a long SQL SELECT going on, I can hit ESC and it will pause. I _think_ there's an option to resume, but it's not feasable for me to set up a test right now. I think you need SET ESCAPE ON or some SET along those lines.
Michelle
>Hi,All,
>I've got an interesting problem. I have a form with multiple buttons to start different things. One of these buttons starts a very lengthy process, progress of which I can monitor on a form (using some common ActiveX controls such as ProgressBar). It all works fine, until I've got a request to make a "Pause" button to suspend that process. My first reaction was to create a "PAUSE" button and put "pause"-related code into Click event. It turns out that the system processed that event after the long process finishes.
>My question is - is it any common methods to pause long process invoked from the form?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only