| about displaying time remaining [message #398031] |
Tue, 14 April 2009 23:41  |
trupti111
Messages: 29
Registered: August 2008
Location: navi mumbai
|
Junior Member |
|
|
I m developing online test system using forms
Whenever a user select a particular test suppose of 10 min.
Then i want to show to user time remaining.
please reply soon n thanks
|
|
|
|
| Re: about displaying time remaining [message #398047 is a reply to message #398031] |
Wed, 15 April 2009 00:31  |
danish_fsd@yahoo.com
Messages: 38
Registered: February 2008
Location: Pakistan
|
Member |
|
|
Hi,
You need to create a timer when user select a particular test and can repeat this to one minute or one second.
Then on WHEN_TIMER_EXPIRED trigger at form level you can write following code.
IF :txt_time > 0 THEN
:txt_time := :txt_time - (TO_NUMBER(TO_CHAR(sysdate,'SS')) - TO_NUMBER(TO_CHAR(sysdate,'SS'))-1));
END IF;
First set "txt_item" text item to your maximum time.
Note the above code is for second count down.
Hope it will help you.
Regards
Danish.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
