Sign Up

❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.

Have an account? Sign In


Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo

OrclQA.Com Navigation

  • Oracle
  • Oracle Apex
  • Python
  • Questions
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Ask Question
  • Add Post
  • Oracle
  • Oracle Apex
  • Python
  • Questions
  • About
  • Questions
  • Answers
  • Best Answers
  • Posts
  • Comments
  1. Asked: December 10, 2020

    add line item for interactive grid

    Mohammed Nasir

    Mohammed Nasir

    • 2 Questions
    • 5 Answers
    • 1 Best Answer
    • 60 Points
    View Profile
    Mohammed Nasir Professional
    Replied to answer on December 15, 2020 at 10:28 am

    Hi Ratana, 1 - First create one dummy hidden  PAGE_ITEM 2 - Create Dynamic Action    Create a dynamic action Event Type as a Get Focus      Selection Type  Column      Region  Your region name     ( My_Region)      Column    Your column name  (Line_Number)     Client_Side Condition   Item/Column isRead more

    Hi Ratana,

    1 - First create one dummy hidden  PAGE_ITEM

    2 - Create Dynamic Action

    1.    Create a dynamic action Event Type as a Get Focus
    2.      Selection Type  Column
    3.      Region  Your region name     ( My_Region)
    4.      Column    Your column name  (Line_Number)
    5.     Client_Side Condition   Item/Column is null
    6.     Component Type   Column
    7.     Column    (Line_Number)

    (1)  Action

    •     Set Value
    •     PL/SQL Expression  _____  NVL(:P1_DUMMY,0)+1
    •     Item to Submit  ____  P1_DUMMY
    •     Affected Elements 
    •    Selection Type  Column
    •    Column   Line_Number
    •    Fire on Initialization    Yes
    •    Stop Execution On Error  Yes
    •    Wait For Result  Yes

    (2) Action

    •     Set Value
    •     PL/SQL Expression _____  NVL(:P1_DUMMY,0)+1
    •     Items to Submit ____  Null
    •     Affected Elements 
    •    Selection Type
    •     Item(s)  P1_DUMMY
    •    Fire on Initialization    Yes
    •    Stop Execution On Error  Yes
    •    Wait For Result  Yes

     

     

    See less
    • 1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter

Sidebar

Explore

  • Ask Question
  • Add Post

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
© 2022 OrclQA.Com. All Rights Reserved.
Privacy Policy - About Us