Re: forms 4.5: using SYSTEM.TRIGGER_ITEM
From: Pete Kolton <peter.kolton_at_nspmbtinternet.com>
Date: Fri, 10 Dec 1999 09:58:24 -0000
Message-ID: <82qinf$3bb$1_at_supernews.com>
Date: Fri, 10 Dec 1999 09:58:24 -0000
Message-ID: <82qinf$3bb$1_at_supernews.com>
> 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'
> */
You don't want to use NAME_IN here.
This will copy the *contents* of the item into v_current_item_name.
If the item is EMP.EMP_NAME and it contains the values 'FRED'...
v_current_item_name := :system.trigger_item puts EMP.EMP_NAME into v_current_item_name
v_current_item_name := NAME_IN(:system.trigger_item) puts FRED into v_current_item_name
-- ======================================================== Pete Kolton ORACLE Systems Consultant All reasonable offers considered :-) Pete_at_kolton.com http://www.kolton.com ========================================================Received on Fri Dec 10 1999 - 10:58:24 CET