I'm working on a form in which block is based on a table.That table consists of fields like request date,refresh date etc.
"Request date" is a mirror of "refresh date" . I'm entering refresh date first.
Request date is a database item and it's required property is set to Yes.It's synchronize with item is set to refresh date.
As soon as I enter a value in refresh date,same value is displayed in request date.When I'm saving those changes,
ORA-1400: cannot insert null
To make it work,
Do I need to change required property to NO and create when-validate-item ?
I don't even remember the last time that I used "sychronize with item" if ever, but as I was playing with it I noticed that when you entered a value for one the items that both were displayed on the canvas, but when you tried to save the record only one of them has the actual value which is why you are getting the error that you are getting.
What I ended up doing was creating two more items in the block DISP_REQUEST_DATE and DISP_REFRESH_DATE and I displayed these on the canvas instead of REQUEST_DATE and REFRESH_DATE.
I then added the DISP_REFRESH_DATE item to the DISP_REQUEST_DATE Synchronize with Item property.
In order for the values to get saved to the database, I created a PRE-INSERT and PRE-UPDATE trigger with the following in both: