OraFAQ Forum: Forms » progress bar based on stored procedure

Home » Developer & Programmer » Forms » progress bar based on stored procedure (Oracle9i 9.2.0.1.0, forms 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

progress bar based on stored procedure [message #376897]

Fri, 19 December 2008 01:15

sweetkhaliq
Messages: 200
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

Report message to a moderator

Re: progress bar based on stored procedure [message #376972 is a reply to message #376897]

Fri, 19 December 2008 05:18

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: progress bar based on stored procedure [message #377219 is a reply to message #376897]

Sun, 21 December 2008 22:23

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

Report message to a moderator

Re: progress bar based on stored procedure [message #377802 is a reply to message #376897]

Thu, 25 December 2008 04:19

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 1524 times)

Report message to a moderator

Re: progress bar based on stored procedure [message #378315 is a reply to message #377219]

Mon, 29 December 2008 23:34

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

Report message to a moderator

Re: progress bar based on stored procedure [message #378390 is a reply to message #378315]

Tue, 30 December 2008 04:05

sweetkhaliq
Messages: 200
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

muz110
Messages: 1
Registered: September 2009
Location: Pakistan

Junior Member

kindly provide me code with sample
at muzafardba@yahoo.com

Report message to a moderator

Previous Topic:	Handling formula Data (Calculation) stored in tables in Oracle forms
Next Topic:	How to use SImplified Chinese and traditional chinese

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 04 03:51:40 CST 2025