Solved

How to use a list_item to trigger a LOV

Posted on 2004-03-28
4
2,640 Views
Last Modified: 2012-08-14
This is for an assignment building a hotel reservation system

Basically I have a list_item, with a variety of elements. I want to be able to select the list_item, choose one of the elements and have it launch an LOV. The user chooses from the list_item (r_type) a value such as "Single with Double Bed". As soon as the user selects this I wanted an LOV to pop up with the available room numbers of that type.

I am using a trigger of WHEN-LIST-CHANGED:
GO_ITEM('CUSTOMER_BLOCK.R_TYPE_LIST');
LIST_VALUES;

When I try this, and run the form, and try changing the drop down list it gives me FRM-41026: Field does not understand operation.

I've searched google all I can and can't seem to find instructions on linking a list_item to a LOV in this way.


Help appreciated, thanks.
0
Comment
Question by:Mooligan
4 Comments
 
LVL 5

Accepted Solution

by:
mudumbe earned 125 total points
Comment Utility
From what I can see, trigger code appears to be correct.  However, I would replace LIST_VALUES to
DO_KEY('LIST_VALUES').

Make sure you have attached the LOV to R_TYPE_LIST...
0
 
LVL 47

Assisted Solution

by:schwertner
schwertner earned 125 total points
Comment Utility
This what you want is need a complex coordination with the list item and the LOV item.
The scenario:
1. user selects an item from the list value.
2. you have to use a trigger on that item (like WHEN-VALIDATE-ITEM) to create the record group of the LOV and to show the LOV itself. So, the choosed value from the list item should take part in the SELECT statement of the Record group associated with the LOV. After that you have to define an item of LOV type, to associate it with the record group.
3. To launch the LOV you have to navigate to the LOV item (from the list-item trigger issue 'GO_ITEM rooms') and an command which as I recall was something like SHOW_LOV (look in the online help).
0
 
LVL 6

Expert Comment

by:musdu
Comment Utility
Hi,

if you show a list-of-value independantly you can use SHOW_LOV built_in; (write below statements in when-list-changed trigger)

IF Show_Lov('MyLOV') THEN
   NULL;
END;

regards
0
 

Author Comment

by:Mooligan
Comment Utility
While I received my answer primarily from the Oracle Tech Net forums, mudumbe and schwertner provided valuable information. I was going to link to the forum response that helped me but the forums are down right now.

Thanks guys
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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

772 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

10 Experts available now in Live!

Get 1:1 Help Now