• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3132
  • Last Modified:

Oracle Forms: Validate-From-List property causes record status change

Hi Everyone,
I have an Oracle Forms riddle for you.  I'm in Oracle Forms 11g.

I have non-base-table item which I change the value of programatically in a post-query trigger.  This should not cause the record status to change (since it's non-base-table), but it does!  When I set the item's Validate-from-List property to 'Yes' and change the value, the record status changes and the user gets prompted to save upon exit when they have not made any changes.  What's going on here and how do I get around this problem?

Thanks
0
leclaude
Asked:
leclaude
1 Solution
 
flow01Commented:
Did you check the column_mapping_property of your lov for return_items that are base-table-items.


In my 10g version I could't reproduce the behaviour.

create  a when_validate_item_trigger on the item and a when validate_record_trigger on the record
put a message in each
message('when valide item x :' ||   :SYSTEM.FORM_STATUS || ';' ||:SYSTEM.BLOCK_STATUS || ';' || :SYSTEM.RECORD_STATUS,ACKNOWLEDGE);
message('when valide record x :' ||   :SYSTEM.FORM_STATUS || ';' ||:SYSTEM.BLOCK_STATUS || ';' || :SYSTEM.RECORD_STATUS,ACKNOWLEDGE);


I  get each  message 2 times : 1 after the post_query and 1 after using the lov and leaving the record. All statusses are QUERY
0
 
leclaudeAuthor Commented:
Yep turned out to be the cause of the problem.  In the LOV column mapping, I had a value being returned into a base table item.  When I took out that mapping the problem went away.
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now