Urgent - Related to Progress Bar

[mukesh]

Urgent : How do I show Status of Progress Bar when executing Stored procedure from the VB.

I have developed an application In VB5.0 Enterprise Version And Backend used is Oracle 7.3

Now when I execute a Stored procedure(which takes lots of time) from the VB 5.0 there is no indication another then Mousepointer which tells me whether something is going on or not(at the VB side). Though I have set my cursor to animated/Hourglass to make user feel that something is going on. But is there any other way by which I can show the status on progressbar. I know when vb execute the stored procedures then it keeps quite(I mean thus nothing till the control come back from the RDO calls).

Is there somesort of code or any third party control which will take care of such requirments.

Can someone please help me in solving this problem.

[Chris Eastwood]

Hi

This all depends on what data access method you are using to talk to Oracle.
I've seen an article on http://www.vbug.co.uk/magazine/i8/oraclefeedback.htm
which shows how you can do what you want using OO4O (Oracle Objects for OLE).

Be warned though, it uses an ActiveX EXE to make all your database calls, and needs
some heavy duty PL/SQL work to talk to messages queues in Oracle.

Or you could always chat to your Oracle DBA and see if he can speed things up a little bit.


Regards

Chris Eastwood

CodeGuru - the website for developers
http://www.codeguru.com/vb

Periodically write a file with the curtrent status in it and run a seperate program that reads
in that file and posts changes to an icon at the bottom of the screen.
The file could contains a string like
"40%" Alpha
"60%" Beta
to indicate that the porgram has completed 40% of function ALPHA and 60% of function BETA
The icon could display the text "40% alpha 60% beta" and would be independent of the other processing going on.
(You might need a refresh routine to update the icon)

The other thing to do is call the program in section saving ints state and post the prograss between each section.
The program should set a series of state variable and be able to reload a state to continue from where it left off.
For example if a program left off at position 1,000,000 in a databse the state vaiable wiould be set to 1,000,000
Any datastructures would be read/written to disk to ensure their state is mainatained. (Use a large block read for best performance).

-- Chris zikacj@aol.com