Re: forms 4.5: using SYSTEM.TRIGGER_ITEM

Thanks Eric, that's what i was looking for. Now why couldn't I find that.....

Martyn.

"Eric C. Janzen" wrote:
>
> Martin,
>
> Use the COPY and NAME_IN commands. Like so:
>
> DECLARE
> v_current_item_name VARCHAR2(40);
> BEGIN
> 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
> --------------------------------------------------
Received on Thu Dec 09 1999 - 17:18:56 CET