Re: Refering to controls

Thanks, I'll look into that. I come from a VB background and it seems so weak of PL/SQL that you cannot explicitly refer to a control on a form when you are writing a trigger. The code in VB would be so simple, you just put a period between the names:

IF mycontrol.value > 10 THEN
> > myform.backgroundcolor = BLUE
> > myform.mycontrol.forgroundcolor = RED
END IF; No matter how I try to refer to it in PL/SQL, I get an error stating that Oracle does not know what field I am talking about.

"Matt B." <mcb_at_ds.znet.com> wrote in message news:tdsbgao22sgv44_at_corp.supernews.com...
> "Tom Deseamus" <elrice2_at_home.com> wrote in message
> news:ixoD6.47374$J%5.15602589_at_news2.rdc2.tx.home.com...
> > Can someone please give me an example of how to refer to controls and
 their
> > properties and values on a form? For example if I wanted to run this
 code,
> > how would I refer to the form, control, and properties.
> >
> > form name := myform
> > control name := mycontrol
> > button name := button1
> >
> > IF mycontrol value > 10 THEN
> > myform background color := BLUE
> > mycontrol forground color := RED
> > END IF;
> >
> > Thanks,
> > Tom
>
> Look at the following in the forms online help:
>
> GET_ITEM_PROPERTY
> SET_ITEM_PROPERTY
> GET_BLOCK_PROPERTY
> SET_BLOCK_PROPERTY
> GET_FORM_PROPERTY
> SET_FORM_PROPERTY
>
> Also look at the SYSTEM variables (e.g.: SYSTEM.CURRENT_FORM,
> SYSTEM.CURSOR_ITEM, etc.). You might also, depending on your needs, want
 to
> look at NAME_IN for if and when you would like to build names dynamically
 in
> your code.
>
> -Matt
>
>
Received on Thu Apr 19 2001 - 04:25:09 CEST