Home » Developer & Programmer » Forms » progress bar based on stored procedure (Oracle9i 9.2.0.1.0, forms 6i)
progress bar based on stored procedure [message #376897] Fri, 19 December 2008 01:15 Go to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Dear Group Members
i am doing work on attendance system. i have written a stored procedute that have insert and update statements and take 15 to 20 seconds to run. The store procedure run from a form command button. I want to show progress bar. I have try to get help from internet but only get the progress bar based on calculations.
Please help me to find out the solution.


I will be very thankfull to you.

Thanks and regards
Re: progress bar based on stored procedure [message #376972 is a reply to message #376897] Fri, 19 December 2008 05:18 Go to previous messageGo to next message
cookiemonster
Messages: 12321
Registered: September 2008
Location: Rainy Manchester
Senior Member
Whenever I've tried to impliment progress bars I've always found they make slow processes even slower.
I suspect you'd be better off trying to speed up your procedure.
icon7.gif  Re: progress bar based on stored procedure [message #377219 is a reply to message #376897] Sun, 21 December 2008 22:23 Go to previous messageGo to next message
rumman
Messages: 48
Registered: June 2007
Location: Bangladesh
Member
Hi sweetkhaliq,

you may easily create a progress bar using your insert or update statement using the following pseudocode:

Use a Display item to show the progress bar named BAR.
------------------------------------------------
Declare
v_total_dml number;
v_total_width_of_bar := 500; -- 100% means 500 width
Begin
v_total_dml := calculate the total number of DMLs;
For i in 1..v_total_dml loop
v_perc:= i/v_total_dml*100;
> your DML here
v_curr_width := v_perc/100*v_total_width_of_bar;
Set_Item_property('BAR',width,v_curr_width);
end loop;
END;
--------------------------------------

Any help you may ask. I will try my best. Razz
Re: progress bar based on stored procedure [message #377802 is a reply to message #376897] Thu, 25 December 2008 04:19 Go to previous messageGo to next message
bhupinderbs
Messages: 67
Registered: July 2006
Location: Bangalore
Member
Attached form may help you for showing progress bar.

Bhupinder Singh
  • Attachment: TEST.fmb
    (Size: 316.00KB, Downloaded 537 times)
Re: progress bar based on stored procedure [message #378315 is a reply to message #377219] Mon, 29 December 2008 23:34 Go to previous messageGo to next message
manudu20
Messages: 45
Registered: August 2008
Location: Mumbai
Member

Hi dear,
Your procedure for "Progress Bar" is not working .
Can you please explain how it will work.

Bye
Thx
Re: progress bar based on stored procedure [message #378390 is a reply to message #378315] Tue, 30 December 2008 04:05 Go to previous messageGo to next message
sweetkhaliq
Messages: 189
Registered: April 2006
Senior Member

Thanks for reply
Dear bhupinderbs.
This progress bar is working quite well. Very good work have been done in this form. Please explain me how progress bar can be used for stored procedure that has insert and update statments.


Thanks and regards.

[Updated on: Tue, 30 December 2008 04:06]

Report message to a moderator

Re: progress bar based on stored procedure [message #430816 is a reply to message #377219] Thu, 12 November 2009 06:59 Go to previous message
muz110
Messages: 1
Registered: September 2009
Location: Pakistan
Junior Member
kindly provide me code with sample
at muzafardba@yahoo.com
Previous Topic: Handling formula Data (Calculation) stored in tables in Oracle forms
Next Topic: How to use SImplified Chinese and traditional chinese
Goto Forum:
  


Current Time: Sat Oct 01 10:58:18 CDT 2016

Total time taken to generate the page: 0.09271 seconds