Oracle Forms (MOSC)

MOSC Banner

FRM-40741

edited Aug 31, 2012 7:49PM in Oracle Forms (MOSC) 1 commentAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center