Home » Developer & Programmer » Forms » about time in forms
about time in forms [message #194455] Fri, 22 September 2006 05:24 Go to next message
jamesrussell15
Messages: 16
Registered: September 2006
Location: philippines
Junior Member

i already have my time in forms but i want to see my seconds running. how? the seconds will change if im going to refresh my window. and how to change the format of hours? i think default hours is 24 but i want to change it by 12 hours. tell me how. thank you.
Re: about time in forms [message #194461 is a reply to message #194455] Fri, 22 September 2006 05:32 Go to previous messageGo to next message
sandeepk7
Messages: 137
Registered: September 2006
Senior Member

use timer with time delay for 1 sec to make ur seconds moving. And for 12Hour format just change the format from HH24:MI:SS to HH:MI:SS.

Sandy
Re: about time in forms [message #194603 is a reply to message #194455] Fri, 22 September 2006 22:06 Go to previous messageGo to next message
jamesrussell15
Messages: 16
Registered: September 2006
Location: philippines
Junior Member

sandy

where im going to place the delay of 1 sec?

thank you.
icon6.gif  Re: about time in forms [message #194632 is a reply to message #194603] Sat, 23 September 2006 02:56 Go to previous messageGo to next message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi

to see the clock running in the form

you should have one text_item or display field

after that

in the form level trigger

When-New-Form-Instance

paste the following code............

..................................................
DECLARE
timer_id Timer;
BEGIN

timer_id := CREATE_TIMER('emp_timer', 1000, REPEAT);

END;
...................................................

then in the form level trigger

When-Timer-Expired

paste the following code...........................

....................................................

:field_name := to_char(sysdate,'HH24:mi:ss');

or

:field_name := to_char(sysdate,'HH:mi:ss pm');

you will get your desired result...

Waiting For Your Reply

Regards

Muhammad Shahid Mughal
Software Developer
Faisalabad Pakistan
Re: about time in forms [message #194648 is a reply to message #194632] Sat, 23 September 2006 09:13 Go to previous message
raizen_underground
Messages: 28
Registered: September 2006
Location: Manila, Phillipines
Junior Member
Muhammad Shahid Mughal...

Pls see the forum entitled 'Matching 2 data between two different block' pls if u hav an idea bout the requirement, pls post it in the forum......tnx in advance.....


raizen......
Previous Topic: web application using form 6i
Next Topic: running my report
Goto Forum:
  


Current Time: Fri Dec 02 12:25:12 CST 2016

Total time taken to generate the page: 0.11151 seconds