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
436 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
pattisp1 earned 0 total points
ID: 22669069
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

617 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