| DATE AND TIME IN FORMS... URGENT! [message #193089] |
Thu, 14 September 2006 20:57  |
jamesrussell15
Messages: 16
Registered: September 2006
Location: philippines
|
Junior Member |
|
|
HELLO THERE!
GUD DAY!
HOW TO CODE THE AUTOMATIC TIME AND DATE IN FORMS.
SO THAT EVERYTIME I LOGGED IN TIME AND DATE ALREADY DISPLAYED.
THANK YOU...
HAVE A NICE DAY!
BADLY NEEDED THIS CODE..
THANKS AGAIN!
RUSSELL
|
|
|
|
|
|
| Re: DATE AND TIME IN FORMS... URGENT! [message #193409 is a reply to message #193089] |
Sat, 16 September 2006 06:22  |
Liza79
Messages: 74
Registered: September 2006
|
Member |
|
|
you can also set the initial value property for the Date Item which is meant to display the current date.
And set the value to $$DBDATE$$ for the date and $$DBTIME$$ for time.
i am not sure about this $ it might be a single, you may check it.
|
|
|
|
|
|
|
|
|
|
| Re: DATE AND TIME IN FORMS... URGENT! [message #203171 is a reply to message #203125] |
Tue, 14 November 2006 03:19 |
 |
saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn
|
Senior Member |
|
|
You can use timer in forms 6i to display a clock.
Method:
Create a Display Item. Data Type is Char.
In When-New-Form-Instance Trigger, write this code:
DECLARE
CurrTime TIMER;
OneSecond CONSTANT NUMBER := 1000;
BEGIN
CurrTime := CREATE_TIMER('CURRTIME',OneSecond,REPEAT);
END;
In When-TImer-Expired Trigger, write this code
DECLARE
ExpTimer VARCHAR2(40) := Get_Application_Property(TIMER_NAME);
vTime Varchar2(30) := :SYSTEM.CURRENT_DATETIME;
BEGIN
IF ExpTimer = 'CURRTIME' THEN
:Your_Block_Nmae.Item_Name := to_char(sysdate,'HH24:MMI:SS');
END IF;
END;
Note:
Using timers in form builder can kill the performance of the machine if the machine has not good configuration.
I'll recommend at least Pentium4 with more than 3GHZ Intel Processor and 512 MB ram.
Search Words : timer, timer in forms6i, clock in forms6i
regards,
Saadat Ahmad
[Updated on: Tue, 14 November 2006 03:21] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
