I have an Oracle stored procedure that I invoke from VB
from a form. I run this asynchronously so that I can continue working with other forms etc while the procedure is executing. The procedure writes it's progress to a table as intervals.
I want to be able to execute some SQL in VB
to retrieve the progress from this table at regular time intervals so that I can use this to display a ProgressBar in VB
to let the user know how far the procedure has executed.
I call this Oracle procedure in UserForm_Initialize of a little form that displays the progressbar. Once the UserForm_Initalize function has been executed, the form shows the progressbar. It is at this stage that I need to invoke the timer and therefore call some VB
function to retrieve the progress from the table.
Has anyone done this before or does anyone know how to execute a VB
function at regular timed intervals?
Many thanks in advance for any help you can provide