OraFAQ Forum: Forms » about time in forms

Home » Developer & Programmer » Forms » about time in forms

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

about time in forms [message #194455]

Fri, 22 September 2006 05:24

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.

Report message to a moderator

Re: about time in forms [message #194461 is a reply to message #194455]

Fri, 22 September 2006 05:32

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

Report message to a moderator

Re: about time in forms [message #194603 is a reply to message #194455]

Fri, 22 September 2006 22:06

jamesrussell15
Messages: 16
Registered: September 2006
Location: philippines

Junior Member

sandy

where im going to place the delay of 1 sec?

thank you.

Report message to a moderator

Re: about time in forms [message #194632 is a reply to message #194603]

Sat, 23 September 2006 02:56

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

Report message to a moderator

Re: about time in forms [message #194648 is a reply to message #194632]

Sat, 23 September 2006 09:13

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......

Report message to a moderator

Previous Topic:	web application using form 6i
Next Topic:	running my report

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 19:15:03 CST 2025