to display a progress bar in oracle form processing [message #80352] |
Fri, 13 September 2002 00:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Susane
Messages: 27 Registered: September 2002
|
Junior Member |
|
|
hi everyone,
can anyone give me an idea how to create or put a progress bar or anything in my program just to notify the user the status of processing program i run is still in process. what i used to is put a message in every process the program do. another option also is i created a stacked canvas and display if still in process and after that hide the stacked canvas to notify the user that the processing is already finished. Please help me finding that codes.. thank you very much for the helped..
susane
|
|
|
Re. To display a progress bar [message #80420 is a reply to message #80352] |
Wed, 18 September 2002 12:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Daniel R
Messages: 8 Registered: September 2002
|
Junior Member |
|
|
Hi susy:
Hi,make a progress bar is very simple, just do the next:
1) create a display_item and give it a static length
that you wish.
2) In the procedure or function where you execute the
main proces that you want the users now that are
running, declare 3 variables as follows:
x number := 225; /* Size of the bar */
z number; /* Size of the step */
c number; /* Counter */
c := 0;
The variable "z" recievs the result of a
SELECT COUNT(*) into z from xxx where xxx; as
follows:
z := x/c;
x := 0;
3) Initialize the bar:
SET_ITEM_PROPERTY('STDTOOLBAR.PROGRESS2',WIDTH,x);
SET_ITEM_PROPERTY('STDTOOLBAR.PROGRESS2' ,VISIBLE,PROPERTY_TRUE);
synchronize;
4) Inside a loop or something put the following line:
The loop could be the main loop or your proces.
x := x + z;
5) Before the loop ends put the following lines:
SET_ITEM_PROPERTY('STDTOOLBAR.PROGRESS2',WIDTH,x);
synchronize;
6) After loop ends write this line:
:STDTOOLBAR.PROGRESS2 := '100%';
synchronize;
set_application_property(cursor_style,'Default');
SET_ITEM_PROPERTY('STDTOOLBAR.PROGRESS2' ,VISIBLE,PROPERTY_FALSE);
7) Separate of this in a WHEN-NEW-FORM-INSTANCE
Trigger put the next line:
SET_ITEM_PROPERTY('STDTOOLBAR.PROGRESS' ,VISIBLE,PROPERTY_FALSE);
8) In a WHEN-BUTTON-PRESSED Trigger put this line:
SET_ITEM_PROPERTY('STDTOOLBAR.PROGRESS' ,VISIBLE,PROPERTY_TRUE);
This procedure works i'm actually using in my forms and it works, just need to change a little things related your aplication. I hope this help, by.
Daniel
|
|
|
|
|