Go Premium for a chance to win a PS4. Enter to Win

x
?
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
Medium Priority
?
440 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
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

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

886 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