4 Replies Latest reply: Jan 30, 2014 5:50 PM by Phil in Sydney RSS

A Quick Question on get value of an item via a variable.

Phil in Sydney Newbie
Currently Being Moderated

Hi there,

 

My database is 11gR2, form server is 10g.

I have a canvas named as canvas14, there is a multi-tab in it (tab1,tab2).

In the 'Key-Exit' trigger, I would like to get current tab name and do something then exit_form.

To get the tab name, I used a function as following.

 

FUNCTION getTabName RETURN varchar2 IS

  tp_nm   VARCHAR2(30);

  tp_id   TAB_PAGE;

  tp_lb   VARCHAR2(30);

BEGIN

  tp_nm := GET_CANVAS_PROPERTY('CANVAS14', topmost_tab_page);

  tp_id := FIND_TAB_PAGE(tp_nm);

  tp_lb := GET_TAB_PAGE_PROPERTY(tp_id, label);

  return tp_lb;

END;

 

In Key-Exit trigger, my part of code is following.

 

v_name := getTabName;

v_item := ':' || v_name||'.des' ;

 

if  v_item is not null then

      clear_form;

else

     exit_form;

end if;

 

v_item is :tab1.des now. I want to get the value of :tab1.des.

How to get the value of v_item, not the variable itself?

 

Thanks in advance.

 

Phil

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points