Solved

Oracle Apex Users can change the status filed on a record from a List of VAlues.   Value is not saving when changed

Posted on 2008-10-07
1
428 Views
Last Modified: 2013-12-18
Users are allowed to change the status of an item from a LOV in a drop down list.  They change this value from the drop down and hit the apply change button.   However, this does not work.  The status is not changed.

The code for the LOV array is as follows:
update TABLE SET STATUS_FLAG = htmldb_application.g_f01(1) where doc_no = :P_doc_no;

0
Comment
Question by:pattisp1
1 Comment
 

Accepted Solution

by:
pattisp1 earned 0 total points
Comment Utility
Hi Everyone.   I am sorry it ended up being a simple solution on the Change status page.   Looks like for some reason a condition was set so the change would not take affect.  Please consider this a closed issue.
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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

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

6 Experts available now in Live!

Get 1:1 Help Now