How to insert the current timestamp only when the record is created
hi,
I am relatively new to APEX and I don't know very much the tips and tricks of it.
I am using a Master/detail form and I want to insert the current timestamp into a database colum ONLY at the moment when the record is created. This will serve as a "creation date". But unfortunately when I update the record (using the form), APIEX automaticallly updates the column with the current timestamp.
This column is a TIMESTAMP type. It is updatted with an item named P42_DATE_CREATION which is Hidden and protected. "Source Type" of the item is DATABASE COLUMN. Alternate Source is "DATE_CREATION".
How to do to write only one time, at creation, the value of the current time stamp instead of beign updated every time the record is edited (I mean the form is updated).
Thank you for your kind help.