Solved

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

Posted on 2012-03-27
2
2,504 Views
Last Modified: 2012-03-28
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
Comment
Question by:leclaude
2 Comments
 
LVL 20

Accepted Solution

by:
flow01 earned 500 total points
Comment Utility
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
 
LVL 1

Author Comment

by:leclaude
Comment Utility
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now