Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: LOV Question

Re: LOV Question

From: <owais_anjum_at_my-deja.com>
Date: Tue, 10 Aug 1999 06:24:59 GMT
Message-ID: <7oogjk$op1$1@nnrp1.deja.com>


In article <01bee29a$490296e0$0e8a8b8e_at_dot-isb-18494.gov.nb.ca>,   "Mark Whalley" <markw_at_gov.nb.ca> wrote:
> I tried doing the following:
> IF group_type =4 THEN
>

Set_Item_Property(:ipps_permits.notified_to,LOV_NAME,'GROUP4_LOV');
> END IF;
>
> I get the following error:
> FRM-41045: Cannot find item: invalid id
>
> Does anyone know how to correct this? or a better method?
>
> Mark Whalley <markw_at_gov.nb.ca> wrote in article
> <01bee293$d302d280$0e8a8b8e_at_dot-isb-18494.gov.nb.ca>...
> > I'm using Oracle Forms 4.5.
> >
> > Can you have an LOV that is based on another item in the form.
> > For example, group_type would we the item that affects the LOV.
> > If group_type=1 the LOV would be one record group and if
group_type=2 it
> > would choose a different LOV.
> > What would be the simplest way to program this?
> >
> >
> this particular error is coming because you are not referencing the
variable correctly.

Set_Item_Property('ipps_permits.notified_to',LOV_NAME,'GROUP4_LOV');

hope it helps

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 10 1999 - 01:24:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US