Assigning a value to display item [message #428768] |
Thu, 29 October 2009 22:42  |
theowais
Messages: 75 Registered: October 2009 Location: Multan
|
Member |
|
|
Dear all,
In a emp-table there is a join-date field.
I want to careate an item field join-day.
It will be a display item and display the day of join-date at run time. Also at the time when I enter a new record.
Please guide me by using your knowledge.
Regards,
M. Owais Ansari
|
|
|
|
|
|
|
|
Re: Assigning a value to display item [message #429514 is a reply to message #429496] |
Wed, 04 November 2009 05:13  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
OracleORA-01846 not a valid day of the week
Cause: A date specified an invalid day of the week. OracleFRM-40735: %s trigger raised unhandled exception %s.
Cause: Application design error. The current trigger raised an exception (other than FORM_TRIGGER_FAILURE), but it did not handle the exception.
Action: Rewrite the trigger text to handle the exception.
I guess you meant to use TO_CHAR function, not TO_DATE. Or, perhaps not. But you might provide additional information (such as ":date" item's datatype and values stored within).
|
|
|