Add a Progress Bar when i call a PL/SQL with ADO Command

Hi i Have a question.... How can i add a progress bar while my VB code call a Stored Procedure?
I have this code:

        Dim oCon As Connection
        Dim oCmd As Command
        Set oCmd.ActiveConnection = oCon
        oCmd.CommandType = adCmdStoredProc
        nRetorno = 0
        oCmd.Parameters.Append oCmd.CreateParameter("n1", adInteger, adParamInput, len(value), value)
        oCmd.Parameters.Append oCmd.CreateParameter("nRetorno", adInteger, adParamOutput)
        oCmd.Parameters.Append oCmd.CreateParameter("sRetorno", adVarChar, adParamOutput, 200)
        oCmd.CommandTimeout = 10000
        DoEvents
        oCmd.Execute
        nRetorno = oCmd.Parameters("nRetorno").
       ... etc.


I ask that because when VB execute this command Line oCmd.Execute the screen waits until the Stored Procedure finish, and the user can´t wait around 10 minutes for example while the PL/SQL process 1 million of records. And for this reason i want to add a Progress Bar, but i don´t know how can i add  this control is this code.

Thanks a lot.
jorgeaniAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
JR2003Connect With a Mentor Commented:
You could use an animation control instead.
Add an animation control to your form. This is available in "Microsoft Common Controls-2"
Put the required animation on in the application directory. These are availabe in the
C:\Program Files\Microsoft Visual Studio\Common\Graphics\Videos
directory.


'In the form load event
Private Sub Form_Load()
    Animation1.Open App.Path & "\search.avi"



'In the function that calls the stored procedure:
    Animation1.AutoPlay = True
    DoEvents 'Allow the animation to run on a separate thread.

    'Call the stored procedure here
    '...
    '...
    '...

    'Stop the animation control
    Animation1.AutoPlay = False

JR
0
All Courses

From novice to tech pro — start learning today.