Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Call creation timestamp changes when record is opened again (4.0)
Call creation timestamp changes when record is opened again [message #551952] Sun, 22 April 2012 19:38 Go to next message
newprogrammerSQ
Messages: 48
Registered: April 2012
Member
currently I have a Text field for Call_Creation which timestamps the date/time as soon as a newcall/record is about to be entered.


defaultvalue=to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS')
Condition type: Not conditional
Read only condition type: Always

this saves perfectly... however when I re open the call to edit changes etc, the timestamp overwrites to the current date...


How can this be modified so it only timestamps on creation of record/call..... and is only read only after that?

[Updated on: Sun, 22 April 2012 19:39]

Report message to a moderator

Re: Call creation timestamp changes when record is opened again [message #551995 is a reply to message #551952] Mon, 23 April 2012 02:05 Go to previous message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In item's Source, try:
Source used               : Always, replacing any existing value in session state
Source type               : Database column
Source value or expression: CALL_CREATION
Previous Topic: Pie chart is showing ID number with , comma
Next Topic: Error in generating pdf report.
Goto Forum:
  


Current Time: Mon Mar 18 21:25:07 CDT 2024