Hello
We have a custom form having 3 blocks, lets say Blk A, Blk B, Blk C.
Blk A is pre-populated from the Post-Query of Blk B and C.
Once additional changes are done to this data, then using a button it is saved in to the actual table of Blk A.
Blk B Post-Query: set_record_property(:system.cursor_record,'Blk B',status,query_status)
Blk C Post-Query: set_record_property(:system.cursor_record,'Blk C',status,query_status)
no set_Record_property for Blk A.
Hence, once the form is opened and closed, we still get the pop-up “Do you want to save the changes?”
Also, if we add set_record_property for Blk A in the post-query of Blk B & C, then we get the “FRM-40654 record has been updated by another user” message.
What should be the approach in this case?