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

Bansari

  • 4 Questions
  • 13 Answers
  • 0 Best Answers
  • 44 Points
View Profile
  • 0
BansariContributor
Asked: May 10, 20212021-05-10T05:10:10+05:30 2021-05-10T05:10:10+05:30

Dynamic action's behavior of set value on a button gives blank output sometimes

  • 0

Hello,

I do have 4 dynamic action on a button(It sets multiple APEX items from database based on input-approx. 30 display only items) and sometimes it gives output for set value in APEX items and sometimes I can see(for 1/2 second I can say) value when I click button and then it disappears.
So not sure whether it's taking value but due to many set value actions it is happening or anything else it's causing.

Note: It happens only few times.
'Fire on Initialization' set to 'No'

Thanks in Advance!

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

6 Answers

  1. Vinish Kapoor

    Vinish Kapoor

    • 1 Question
    • 727 Answers
    • 63 Best Answers
    • 4k Points
    View Profile
    Vinish Kapoor Enlightened
    2021-05-10T07:52:42+05:30Added an answer on May 10, 2021 at 7:52 am

    It is definitely conflicting with other set value dynamic actions. You will have to check.

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

      Bansari

      • 4 Questions
      • 13 Answers
      • 0 Best Answers
      • 44 Points
      View Profile
      Bansari Contributor
      2021-05-11T02:27:51+05:30Replied to answer on May 11, 2021 at 2:27 am
      This answer was edited.

      Do same select fields with different where condition considered as a conflict in dynamic actions?
      To be more precise:
      4 Dynamic action:
      - 2(4 + 4 true actions) with same select statements, client-side condition and different where condition
      - 2(4 + 4 true actions) with same select statements, client-side condition and different where condition

      • 0
      • Share
        Share
        • Share on Facebook
        • Share on Twitter
      • Vinish Kapoor

        Vinish Kapoor

        • 1 Question
        • 727 Answers
        • 63 Best Answers
        • 4k Points
        View Profile
        Vinish Kapoor Enlightened
        2021-05-11T07:22:15+05:30Replied to answer on May 11, 2021 at 7:22 am

        It will definitely conflict if a select statement will set a value for an item, then another with a different where clause may set to null again.

        You should write a single statement to handle all where clauses for the same items.

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

          Bansari

          • 4 Questions
          • 13 Answers
          • 0 Best Answers
          • 44 Points
          View Profile
          Bansari Contributor
          2021-05-11T18:10:58+05:30Replied to answer on May 11, 2021 at 6:10 pm

          I'm really sorry to confuse you all here.

          Actually all those true actions with different where condition is setting different values.
          I'm having 40 items
          - 2 dynamic actions(taking 2 inputs(5/11/21,previous), 4+4 true actions): Setting 40 items, and all 8 true actions have different affected elements(items) from 40
          - 2 dynamic actions(taking 2 inputs(5/11/21,next), 4+4 true actions): Setting the same 40 items, and all 8 true actions have different affected elements(items) from 40

          So, I can only say it is setting the same 40 items only when input changes between 'previous' and 'next', also when I say different where condition that means I'm comparing input date different year like
          to_char(f.statement_dt, 'yyyymm') = to_char(add_months(:P10_START_DATE,-24), 'yyyymm')

          I hope I'm making clear point. Again sorry for the confusion.
          Thanks!

          • 0
          • Share
            Share
            • Share on Facebook
            • Share on Twitter
  2. Abdul Aqeel Malik

    Abdul Aqeel Malik

    • 6 Questions
    • 20 Answers
    • 0 Best Answers
    • 79 Points
    View Profile
    Abdul Aqeel Malik Professional
    2021-05-11T02:41:53+05:30Added an answer on May 11, 2021 at 2:41 am

    Did you check submit items??

    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
    • Bansari

      Bansari

      • 4 Questions
      • 13 Answers
      • 0 Best Answers
      • 44 Points
      View Profile
      Bansari Contributor
      2021-05-11T18:11:28+05:30Replied to answer on May 11, 2021 at 6:11 pm

      Yes, I checked all the submit items.

      • 0
      • 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