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
ratana
ratana

ratana

  • 6 Questions
  • 19 Answers
  • 0 Best Answers
  • 56 Points
View Profile
  • 0
ratanaProfessional
Asked: December 10, 20202020-12-10T19:21:00+05:30 2020-12-10T19:21:00+05:30

add line item for interactive grid

  • 0

Hi,

i have interactive grid to save item data. Line item is using JS to get number whenever there is new item. after saving IG, return line item from table, but whenever i click butt "Add Item", IG count from 1 and become duplicate Line Item number. Here is screenshot after saving:

 

when add new item to update IG data:

 

How to fix it? it could be start from 2 or count from the last number of line item.

 

Thanks,
Ratana

question
  • 6
  • 289
  • 0
  • 0
  • Share
    • Share on Facebook
    • Share on Twitter
    • Share on LinkedIn
Answer

6 Answers

  1. Mohammed Nasir

    Mohammed Nasir

    • 2 Questions
    • 5 Answers
    • 1 Best Answer
    • 60 Points
    View Profile
    Mohammed Nasir Professional
    2020-12-13T14:24:19+05:30Added an answer on December 13, 2020 at 2:24 pm

    Hi

    Ratana,

    I have done an example like that see above image,

    for this one we have done dynamic action set value PLSQL Expression use

    in dummy hidden item

     

     

     

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • ratana

      ratana

      • 6 Questions
      • 19 Answers
      • 0 Best Answers
      • 56 Points
      View Profile
      ratana Professional
      2020-12-13T14:42:14+05:30Replied to answer on December 13, 2020 at 2:42 pm

      hi,

       

      image is very low resolution which cannot view the code.

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Mohammed Nasir

        Mohammed Nasir

        • 2 Questions
        • 5 Answers
        • 1 Best Answer
        • 60 Points
        View Profile
        Mohammed Nasir Professional
        2020-12-14T21:42:21+05:30Replied to answer on December 14, 2020 at 9:42 pm

        Please check now

        • 0
        • Share
          Share
          • Share on Facebook
          • Share on Twitter
  2. Mohammed Nasir

    Mohammed Nasir

    • 2 Questions
    • 5 Answers
    • 1 Best Answer
    • 60 Points
    View Profile
    Mohammed Nasir Professional
    2020-12-14T21:38:03+05:30Added an answer on December 14, 2020 at 9:38 pm
    This answer was edited.

    Please check again

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • ratana

      ratana

      • 6 Questions
      • 19 Answers
      • 0 Best Answers
      • 56 Points
      View Profile
      ratana Professional
      2020-12-15T09:02:56+05:30Replied to answer on December 15, 2020 at 9:02 am

      Can you help to detail "Set_Line_Number"?

      Event: Get Focus

      Selection Type: ???

      Region: ??

      Column: ??

       

      Thanks!

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Mohammed Nasir

        Mohammed Nasir

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

        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

         

         

        • 1
        • Share
          Share
          • Share on Facebook
          • Share on Twitter

You must login to add an answer.

Forgot Password?

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