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: June 25, 2021

    Want to have Submit ability after checking Validation

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied to answer on June 28, 2021 at 7:26 am
    This answer was edited.

    Hello, On a button click event, after firing the error message(From the ajax call-back process), it is not submitting again. It is taking as a second submission and showing the same error message. What would be the solution to have it on button click event? Thanks!

    Hello,

    On a button click event, after firing the error message(From the ajax call-back process), it is not submitting again. It is taking as a second submission and showing the same error message.

    What would be the solution to have it on button click event?

    Thanks!

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: June 25, 2021

    Want to have Submit ability after checking Validation

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied to answer on June 25, 2021 at 8:01 am

    Thank you for your quick response and providing alternative. But I do have a question is the solution possible that it validates only when we click submit as I’m having 2 other different buttons and this is checking every time as it has lose focus. I only want to check it when user clicks submit butRead more

    Thank you for your quick response and providing alternative.

    But I do have a question is the solution possible that it validates only when we click submit as I’m having 2 other different buttons and this is checking every time as it has lose focus. I only want to check it when user clicks submit button and not check if other 2 buttons clicked.

    Thanks!

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: May 10, 2021

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

    Bansari

    Bansari

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

    Yes, I checked all the submit items.

    Yes, I checked all the submit items.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: May 10, 2021

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

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied 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 elementRead more

    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!

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: May 10, 2021

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

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied 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, clientRead more

    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

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: March 26, 2021

    How to have an APEX item with arithmetic ability in APEX 19.1

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied to answer on April 8, 2021 at 7:38 pm

    Please help me out to close this as it is getting crucial for my project. Thanks in advance for all your extra effort.

    Please help me out to close this as it is getting crucial for my project.

    Thanks in advance for all your extra effort.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: March 26, 2021

    How to have an APEX item with arithmetic ability in APEX 19.1

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied to answer on April 7, 2021 at 4:59 pm

    Yes, you are right, I tried but it’s not calculating values. Is there any other way? Format mask also not supporting. And tried plug-ins too, but those ones are not allowing me to enter numbers like 1000-500.

    Yes, you are right, I tried but it’s not calculating values.
    Is there any other way?
    Format mask also not supporting.
    And tried plug-ins too, but those ones are not allowing me to enter numbers like 1000-500.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: March 26, 2021

    How to have an APEX item with arithmetic ability in APEX 19.1

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied to answer on April 7, 2021 at 8:45 am

    Ok, I can double check my function and fields, But please let me know how to achieve format within those numbers as it is equal important for me with this arithmetic ability. I have tried “ Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')" within function.

    Ok, I can double check my function and fields,
    But please let me know how to achieve format within those numbers as it is equal important for me with this arithmetic ability.
    I have tried “ Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')"
    within function.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: March 26, 2021

    How to have an APEX item with arithmetic ability in APEX 19.1

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied to answer on April 5, 2021 at 7:15 pm

    I tried below function function fnc_calcTotal() { var n_sales, n_cost, n_profit; n_sales = eval($v("P11_SALES")); $s("P11_SALES", n_sales); n_cost = eval($v("P11_COST")); $s("P11_COST", n_cost); n_sales = parseFloat($v("P11_SALES"), 10) ? parseFloat($v("P11_SALES"), 10) : 0; n_cost = parseFloat($v("Read more

    I tried below function

    function fnc_calcTotal() {
    var n_sales, n_cost, n_profit;
    n_sales = eval($v("P11_SALES"));
    $s("P11_SALES", n_sales);
    n_cost = eval($v("P11_COST"));
    $s("P11_COST", n_cost);
    n_sales = parseFloat($v("P11_SALES"), 10) ? parseFloat($v("P11_SALES"), 10) : 0;
    n_cost = parseFloat($v("P11_COST"), 10) ? parseFloat($v("P11_COST"), 10) : 0;
    n_profit = n_sales - n_cost;
    $s("P11_PROFIT", parseFloat(n_profit, 10));
    }

    Removed custom attribute and eval function from both P11_SALES and P11_COST as you mentioned
    But, it is not giving me P11_PROFIT calculated and, Where can I add format part as I have to implement it?

    Thanks

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: March 26, 2021

    How to have an APEX item with arithmetic ability in APEX 19.1

    Bansari

    Bansari

    • 4 Questions
    • 13 Answers
    • 0 Best Answers
    • 44 Points
    View Profile
    Bansari Contributor
    Replied to answer on April 1, 2021 at 7:37 pm

    I guess because I'm using onfocusout="this.value=Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')" as well on both the fields and then I do have 2 JS code implementing in dynamic action for both items.

    I guess because I'm using
    onfocusout="this.value=Number(this.value).toFixed(2).replace(/(\d)(?=(\d{3})+(?!\d))/g, '$1,')"
    as well on both the fields
    and then I do have 2 JS code implementing in dynamic action for both items.

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

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