Re: List of Values in Enter-Query Mode

Two questions:

1. Is the KEY-LISTVAL trigger at the block level?
2. What is the parameter I need to pass to LIST_VALUES? Under Built-Ins, I see this: LIST_VALUES(KWD IN NUMBER). What is an example of KWD?

Thanks.

Dennis

In article <6vlchh$mi7$1_at_nnrp1.dejanews.com>,   aupadhya_at_bbn.com wrote:
> By default list of values doesn't work in enter query mode. What you should do
> is write a trigger KEY-LISTVAL and call built in LIST_VALUES there. Now go to
> the property of the trigger and enable fire in query mode to TRUE.
>
> Hope this works
>
> In article <6ubj6h$42p$1_at_nnrp1.dejanews.com>,
> dennishancy_at_eaton.com wrote:
> > I have a non-base-table field on a custom Oracle form. Associated with this
> > field is an LOV. The LOV works fine in "normal" mode; however, when I try
to
> > open up the LOV during a query, I get this error:
> >
> > APP-01345: List of Values is not
> > available for this field while in
> > Enter-Query mode
> >
> > I should also point out that I'm running the form in Oracle Apps. I checked
> > the properties for this field, and "Query Allowed" is set to true.
> >
> > What am I forgetting?
> >
> > Dennis Hancy
> > Eaton Corporation
> > Cleveland, OH
> >
> > -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 12 1998 - 16:09:12 CEST