Forum Stats

  • 3,852,797 Users
  • 2,264,139 Discussions
  • 7,905,145 Comments

Discussions

Page Items not displaying values

Comet
Comet Member Posts: 176 Blue Ribbon
edited Dec 19, 2013 10:02AM in APEX Discussions

I created a page in APEX 4.2.3.00.08.  I added two text field page items named P3_FROM_RANGE & P3_TO_RANGE.   I also defined a dynamic action on the page named GET_RANGE with the following sql in the PL/SQL Code property under Settings for the True Action:

begin

select grt.from_key_fob_num

, grt.to_key_fob_num

into :P3_FROM_KEY_FOB_NUM, :P3_TO_KEY_FOB_NUM

from apextds.gen_range_tab grt;

end;

The GET_RANGE dynamic action is programmed to execute when :P3_TDS_NUM CHANGES VALUE. That is to say the WHEN properties of the dynamic action are:

Event: Change

Selection Type: Item(s)

Item(s): P3_TDS_NUM

Condition: not equal to

Value: ALL

When I change P3_TDS_NUM the session state indicates the dynamic action is executed for the indicated conditions and the text field page items :P3_FROM_KEY_FOB_NUM, :P3_TO_KEY_FOB_NUM have the correct values but they do NOT display on the page.  (If I edit the page and then apply changes and run the page the correct values appear, obviously not a run-time scenario.) 

How do I refresh the text field page items so the values appear when the dynamic action is executed? Is this an issue with a page property, an item property, or the dynamic action properties?

Tagged:

Answers

  • Hi Comet,

    Well you don't need to refresh the items, but you do need to fill in your items in the return items in your PL/SQL actions that you want the value to be inserted, otherwise you just change their session value and not their browser value.

    Regards,

    Joni

    Joni Vandenberghe
  • Comet
    Comet Member Posts: 176 Blue Ribbon

    I made some progress along the lines of what you suggest but I am still having a problem.  I am going to open a new discussion with the revised problem statement.  If you care to take a loke the title of the discussion is 'Dynamic Action Out of Sync.'

    Thanks

This discussion has been closed.