This content has been marked as final. Show 2 replies
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:
That seems to work in the form I created trying to emulate your problem.
:temp_table.request_date := :temp_table.disp_request_date; :temp_table.refresh_date := :temp_table.disp_refresh_date;
Both Refresh Date and Request Date are in the same table? set the properties of the item where you are synchronise with item the below property should be set.
to Synchronise Set the Data Property --> synchronise which item?
remember both item data should be the same. (Ex: Date = Date)
if one of your item is non database item then mirror property should be Database_item =No in database property.