Re: LOV - normalmode/querymode

In article <6tmb4m$h5k$1_at_nnrp1.dejanews.com>,   gayatribalaji_at_my-dejanews.com wrote:
> Thanks ,
> IT WORKS GREAT!!!!
> gayatri
>
> In article <6tc6s9$l09_at_bgtnsc02.worldnet.att.net>,
> "Madhu Cherukuri" <madhuc_at_hotmail.com> wrote:
> > You can do this progragamatically by using
> >
> > IF MY_CONDITION THEN
> > SET_ITEM_PROPERTY('ITEM_NAME', LOV_NAME, 'MY_LOV');
> > ELSE
> > SET_ITEM_PROPERTY('ITEM_NAME', LOV_NAME, 'NEW_LOV');
> > END IF;
gayatri,

why not use *one* LOV with *one* rec. grp.

MY_LOV has query:

 select * from dept;

NEW_LOV has query:

 select * from dept where deptno = :emp.deptno;

Instead of these two LOVs, use one LOV with the following query:

 select * from dept where
  ((:SYSTEM.MODE = 'ENTER_QUERY')) OR
  ((:SYSTEM.MODE = 'NORMAL') AND
    deptno = :emp.deptno);

Regards,

Robert.
rtgraf_at_sintec.de

> >
> > HTH
> >
> > Madhu Cherukuri
> >
> > gayatribalaji_at_my-dejanews.com wrote in message
> > <6tbmpa$3a5$1_at_nnrp1.dejanews.com>...
> > >Hi,
> > >FORMS 4.5,oracle 7.x,windows 95
> > >
> > >I need to show two lovs for a particular item manager.
> > >When the form is in normal mode I need to populate all managers but
> > >when the form is in query mode I need to populate restricted managers.
> > >I am able to attach only one lov to a particular item at design time,
> > >I guess it needs to be done programmatically at run time.
> > >
> > >Can anyone guide me on this...
> > >
> > >gayatri
> > >
> > >
> > >-----== 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 Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

--
Robert Graf-Waczenski e-mail: rtgraf_at_sintec.de
Visit our web site!   http://www.sintec.de

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp   Create Your Own Free Member Forum