Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

When closing the Form "Do you want to save changes" window

user525275Oct 30 2009 — edited Nov 2 2009
Hi
I have a Master-Detail form where in my POST-QUERY trigger i am changing the LOV non-database item field to some value. When I just select Master record(NOT in query mode) my detail records pop up in the detail block. This is done by EXECUTE_QUERY in WHEN-NEW-BLOCK-INSTANCE trigger in Detail Block. But when i close the form it asks me to save changes even though i haven't changed anything. I have this statement in POST-QUERY Trigger
SET_RECORD_PROPERTY(:SYSTEM.TRIGGER_RECORD,:SYSTEM.TRIGGER_BLOCK,STATUS,QUERY_STATUS); This issue does not happen in QUERY-MODE.

I tried both Set_Item_Property('BLOCK.CODE',ITEM_IS_VALID,PROPERTY_TRUE); this property in the POST_QUERY and Set_Item_Property('item_name',VALIDATE_FROM_LIST,PROPERTY_TRUE); in QUERY-MASTER-DETAILS trigger but it didn't work.

please help

thanks
This post has been answered by Andreas Weiden on Nov 2 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2009
Added on Oct 30 2009
35 comments
8,868 views