FRM-40741
Hello,
I have a problem with a Master detail form where the form forces user to enter values in required field of detail, EVEN WHEN the form is in query mode. This happens only when criteria based query is supplied. This behavior does not occur when execute query for all records is applied.
To solve this problem,
I had to write a POST-QUERY trigger at MASTER BLOCK level.
And in that trigger, following was set
set_record_property(:SYSTEM.CURSOR_RECORD, 'MASTER_BLOCK',STATUS,QUERY_STATUS);
As a result, I am able to hit F11 and query the record based on a criteria. Now, it no longer forces user to enter values in required fields of detail block when the form is in query mode.
I have a problem with a Master detail form where the form forces user to enter values in required field of detail, EVEN WHEN the form is in query mode. This happens only when criteria based query is supplied. This behavior does not occur when execute query for all records is applied.
To solve this problem,
I had to write a POST-QUERY trigger at MASTER BLOCK level.
And in that trigger, following was set
set_record_property(:SYSTEM.CURSOR_RECORD, 'MASTER_BLOCK',STATUS,QUERY_STATUS);
As a result, I am able to hit F11 and query the record based on a criteria. Now, it no longer forces user to enter values in required fields of detail block when the form is in query mode.
0