OraFAQ Forum: Forms » process bar

Home » Developer & Programmer » Forms » process bar

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

process bar [message #120216]

Wed, 18 May 2005 08:57

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

hi every body
i have database procedure update and insert record in tables
could i crete bar on form to syncronize with this process as process bar
thnx

Report message to a moderator

Re: process bar [message #120303 is a reply to message #120216]

Wed, 18 May 2005 21:01

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I think the only way to synchronise a progress bar is to control the loop from within your form and to 'refresh/increment' the progress bar from that loop.

For example:
Loop i from 1 to number_of_records
display_bar(i/number_of_records as a %)
synchronise
update or insert
end loop

The display_bar can be done every update/insert or conditionally done ever 5%, for example.

The key thing is that you have to control the process from the Form, not the database procedure.

David

Report message to a moderator

Re: process bar [message #120436 is a reply to message #120216]

Thu, 19 May 2005 14:03

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

it's procedure from database package so
is there any way to know that the procedure or function still in progress

Report message to a moderator

Re: process bar [message #120531 is a reply to message #120436]

Fri, 20 May 2005 06:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Set your cursor to 'busy' then 'synchronize' then start database procedure. When it finishes and returns to the form, set the cursor back to 'normal'.

David

Report message to a moderator

Re: process bar [message #120592 is a reply to message #120531]

Fri, 20 May 2005 10:53

vban2000
Messages: 207
Registered: March 2005

Senior Member

Hi David

Could you please, tell me where is the function of display_bar
and how could we use it...

and also how to one set cursor to 'busy' and 'normal' ??

thanks very much in Advance
Andy

Report message to a moderator

Re: process bar [message #120669 is a reply to message #120216]

Sun, 22 May 2005 07:44

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

yeah andy

i'd like to ask the same question
where is this function

Report message to a moderator

Re: process bar [message #120803 is a reply to message #120669]

Mon, 23 May 2005 17:30

danosw
Messages: 20
Registered: May 2005
Location: California

Junior Member

changing the mouse pointer:
SET_APPLICATION_PROPERTY(CURSOR_STYLE,'NORMAL'); --- pointer
SET_APPLICATION_PROPERTY(CURSOR_STYLE,'BUSY'); -- hourglass

To create a "progress" bar, you will have to re-code your database procedure or create a background process that calls yours database procedure.

Report message to a moderator

Re: process bar [message #120834 is a reply to message #120216]

Tue, 24 May 2005 03:30

Gurusubramanyam
Messages: 79
Registered: July 2001

Member

Hi,

Please check the following link. There are some examples availble related to progress bar implemetation in D2K.

Hope this will be helpful to you.

http://ourworld.compuserve.com/homepages/Peter_Koletzke/tip.htm

Regards,
G.S

Report message to a moderator

Previous Topic:	i want to keep an icon to the push button..
Next Topic:	update button

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:57:39 CDT 2024