| urgent help needed [message #86589] |
Tue, 12 October 2004 23:02  |
odeveloper
Messages: 34
Registered: September 2004
|
Member |
|
|
how do i update current time using sysdate in Form as its always updating 1200 for DATE datatype field, when i m using to_char, Form generating Unhandelled exception error. thnx for your help.
|
|
|
|
| Re: urgent help needed [message #86595 is a reply to message #86589] |
Wed, 13 October 2004 00:21  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
In,
Pre-Update/Pre-Insert triggers set the value of that feild to SYSDATE.
Also do not forget to Change the Datatype of feild to DATETIME in your form, if you wish to view the Date along with time.
HTH
Regards
Himanshu
|
|
|
|
| Re: urgent help needed [message #86600 is a reply to message #86595] |
Wed, 13 October 2004 02:40 |
odeveloper
Messages: 34
Registered: September 2004
|
Member |
|
|
thank you Himanshu for reply.
i already tried this but failed.
plz take a few moments to read what i m doing.
for table emp i made temp form and used property for hiredate, sets type to 'Datetime' initial value to '$$datetime$$' and format mask to 'dd-mon-y hh:mi', when inserting data its ok saving date with time but when using Pre-Update trigger as:
select to_date(sysdate,'dd-mon-yy hh:mi')
into :hiredate
from dual;
its updating but time is initialized to 12:00 and if using to_char instead of to_date then Form returns error. i dont know whats wrong bcoz INSERT is working fine.
thank you again for your valueable time and help.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
