Re: forms 4.5: using SYSTEM.TRIGGER_ITEM

From: Eric C. Janzen <ejanzen_at_telusplanet.net>
Date: Thu, 09 Dec 1999 16:01:38 GMT
Message-ID: <CnQ34.27168$n3.410411_at_news1.telusplanet.net>


Martin,

[Quoted] Use the COPY and NAME_IN commands. Like so:

DECLARE
  v_current_item_name VARCHAR2(40);
BEGIN
[Quoted] [Quoted]   v_current_item_name := NAME_IN(:system.trigger_item);

  /*
  ** The above line will return the block.item of the current item,
  ** so if the cursor is on :EMP.EMP_NAME, the value of
  ** v_current_item_name will be 'EMP.EMP_NAME'
  */
  COPY ('Generic Name',v_current_item_name)
  /*
  ** This is essentially the same as doing :
  ** COPY 'Generic Name','emp.emp_name');
  ** OR
  ** :emp.emp_name := 'Generic Name';

  */
END; Hope that helps.
--
--------------------------------------------------
Eric Janzen
E. Janzen Consulting Inc.
Oracle Development Specialist
--------------------------------------------------



Martyn Dissington <mdiss2bu_at_mail.burton-college.ac.uk> wrote in message
news:384FCF93.11F6E170_at_mail.burton-college.ac.uk...

>
> I'm not trying to alter SYSTEM.TRIGGER_ITEM, I'm trying to set the value
> of the item that it is returning. Is there a way to do that using
> Set_Item_Property? I didn't think that there was.
>
> Something that did
> Set_Item_Value(:SYSTEM.TRIGGER_ITEM,'HELLO');
> is what I am effectively looking for.
>
> Martin Angers wrote:
> >
> > Read-only property...
> > You can't assign a value to SYSTEM.TRIGGER_ITEM. However, you CAN use
the
> > result of FIND_ITEM (or use the value of the SYSTEM variable directly)
and
> > the use SET_ITEM_PROPERTY to assign a value to a particular property of
the
> > item (see the SET_ITEM_PROPERTY help in Forms 4.5 for details).
> >
> > HTH,
> >
> > Martin Angers
> > Larochelle Gratton
> > mangers_at_larochelle-gratton.com
> >
> > Martyn Dissington a écrit dans le message
> > <384FBE9C.3A3B967F_at_burton-college.ac.uk>...
> > >I am using the :SYSTEM.TRIGGER_ITEM to get the
> > >item name that originated a trigger. What i would
> > >like to do is assign a value to this item.
> > >
> > >I have tried doing
> > >:SYSTEM.TRIGGER_ITEM := [whatever]
> > >Find_Item(:SYSTEM.TRIGGER_ITEM) := [whatever]
> > >
> > >I have also declared an 'Item' variable assigned
> > >it the result of Find_Item(:SYSTEM.TRIGGER_ITEM)
> > >and then tried to do
> > >
> > >Item := [whatever]
> > >
> > >None of these work. How can you accomplish this?
> > >
> > >---
> > >
> > >Could any replies be CC'd to
> > >< mdiss2bu_at_burton-college.ac.uk >
> > >
> > >thanks in advance,
> > >
> > >Martyn.
Received on Thu Dec 09 1999 - 17:01:38 CET

Original text of this message