Sign Up

Hey, Dev!
Are you looking for a forum full of active developers to help you?
So if you want to:
➡️ Get answers for your development issues
➡️ Help others
➡️ Write an article
➡️ Get rewarded for your active participation
Then this place is just for you 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

Sorry, you do not have a permission to ask a question, You must login to ask question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

OrclQA.Com

OrclQA.Com Logo OrclQA.Com Logo
Search
Ask A Question

Mobile menu

Close
Ask a Question
  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About
Home/Farooq Ahmad/Answers
  • About
  • Questions
  • Answers
  • Best Answers
  • Followed Questions
  • Favorite Questions
  • Posts
  • Comments
  • Followers Questions
  • Followers Answers
  • Followers Posts
  • Followers Comments
  1. Asked: October 23, 2020

    Rate doesn't take from database when query/Item selection

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 24, 2020 at 1:24 am

    your question is not explain well but what i get is. you need create DA on item_code and set value then sql query select rate from item where item_code=:P2_ITEM_CODE item to submit and effected item rate you will get what you want if this not your requirement please explain

    your question is not explain well but what i get is.

    you need create DA on item_code and set value then sql query

    select rate from item where item_code=:P2_ITEM_CODE

    item to submit and effected item rate

    you will get what you want

    if this not your requirement please explain

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  2. Asked: October 13, 2020

    Run Oracle RDF Report from Oracle Apex 20.1

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 13, 2020 at 8:27 pm

    The best Way To Call RDF Install Application Server Then In cgicmd file create keyname of user credentials .then create substitutions like REP_URL and value http://localhost:7778/reports/rwservlet?keyname&destype=cache&desformat=pdf now go page from where you want call javascript:window.openRead more

    The best Way To Call RDF Install Application Server Then In cgicmd file create keyname of user credentials .then create substitutions like

    REP_URL and value http://localhost:7778/reports/rwservlet?keyname&destype=cache&desformat=pdf

    now go page from where you want call

    javascript:window.open('&REP_URL.&REPORT=C:\REP\filelename.rep&P_1=&P2_INV_CODE.', '_blank');

     

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  3. Asked: October 11, 2020

    Dynamic Action Redirect To Another Page in Oracle Apex

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 11, 2020 at 6:36 pm

    Dear Sir Page 3 is Modal dialog page and there is one page item name :P3_CODE in i want pass from Page 2 this &REP_URL.&REPORT=&REP_DIR.Invoice.rep&PRM_CODE=&GLB_CODE.&PRM_NUM=&P2_CODE. this all will go to p3 page item not in URL

    Dear Sir Page 3 is Modal dialog page and there is one page item name :P3_CODE in

    i want pass from Page 2 this &REP_URL.&REPORT=&REP_DIR.Invoice.rep&PRM_CODE=&GLB_CODE.&PRM_NUM=&P2_CODE.

    this all will go to p3 page item not in URL

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  4. Asked: October 7, 2020

    How to Open any Window Program (Paint/Calculator)

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 7, 2020 at 9:44 pm
    This answer was edited.

    Calculator button DA executes JavaScript. window.open('Calculator:///'); save and run click btn it will open in a new tab; click on open calculator paint never try, but I must say you try on it

    Calculator button DA executes JavaScript.

    window.open('Calculator:///'); save and run click btn it will open in a new tab; click on open calculator paint never try, but I must say you try on it

    See less
    • -1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  5. Asked: October 5, 2020

    Developer Suite with windows server 2019

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Replied to answer on October 7, 2020 at 9:23 pm
    This answer was edited.

    If you are getting fail as you run the setup, then first set virtual memory. Then restart your machine and use compatibility mode, and it will pass.

    If you are getting fail as you run the setup, then first set virtual memory.

    Then restart your machine and use compatibility mode, and it will pass.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  6. Asked: October 6, 2020

    Inline Dialog Refresh before opening

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Replied to answer on October 7, 2020 at 9:20 pm
    This answer was edited.

    Thanks sir, great now, my requirements change a little. I have three-page items and one global parameter, and this all combines I pass into one another page item (: P2_QRY) and from that :P2_QRY the inline dialogue will run .... as I changing the parameter of page items :P2_QRY is not updating, andRead more

    Thanks sir, great now, my requirements change a little. I have three-page items and one global parameter, and this all combines I pass into one another page item (: P2_QRY) and from that :P2_QRY the inline dialogue will run .... as I changing the parameter of page items :P2_QRY is not updating, and I use the following method. in :P2_QRY default SQL query:

     SELECT || '&GLOBAL_CODE=' || 
    :GLOBAL_CODE ||
    '&PRM1=' || :P2_PRM1 || '&PRM_2=' || :P2_PRM2 ||
    '&PRM_DATE_FROM=' || :P2_DATE_FROM || '&PRM_DATE_TO='
    || :P2_DATE_TO AS D FROM DUAL;

    I hope I explain it well.

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  7. Asked: October 5, 2020

    Developer Suite with windows server 2019

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 5, 2020 at 8:31 pm

    i did it on 2016 and its working what error coming to you

    i did it on 2016 and its working what error coming to you

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  8. Asked: October 1, 2020

    Display Image in Interactive Grid Report Apex 20.1

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 5, 2020 at 8:21 pm

    select "ID","NAME",sys.dbms_lob.getlength("PIC")"PIC","MIMETYPE","FILENAME", decode(nvl(dbms_lob.getlength(PIC),0),0,null, '<img alt="'||apex_escape.html_attribute(NAME)||'" title="'||apex_escape.html_attribute(NAME) ||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radiRead more

    select "ID","NAME",sys.dbms_lob.getlength("PIC")"PIC","MIMETYPE","FILENAME",
    decode(nvl(dbms_lob.getlength(PIC),0),0,null,
    '<img alt="'||apex_escape.html_attribute(NAME)||'" title="'||apex_escape.html_attribute(NAME)
    ||'" style="border: 4px solid #CCC; -moz-border-radius: 4px; -webkit-border-radius: 4px;" '
    ||'src="'||apex_util.get_blob_file_src('P14_PIC',ID)||'" height="75" width="75" />') detail_img
    from "INFO"

     

    then change tyle of detail_image to percent grap

    See less
    • -1
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  9. Asked: October 1, 2020

    Display Image in Interactive Grid Report Apex 20.1

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 1, 2020 at 6:11 pm

    hi your blob column will store on db or it will come from path

    hi your blob column will store on db or it will come from path

    See less
    • 0
    • Share
      Share
      • Share on Facebook
      • Share on Twitter
  10. Asked: September 16, 2020

    Wizard Style Form in Apex

    Farooq Ahmad

    Farooq Ahmad

    • Lahore, Pakistan
    • 17 Questions
    • 22 Answers
    • 0 Best Answers
    • 179 Points
    View Profile
    Farooq Ahmad Professional
    Added an answer on October 1, 2020 at 6:06 pm

    My Chanel may be help you https://youtu.be/SAOmrPYutCQ

    My Chanel may be help you

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

Sidebar

Ask Question
Write a Post
  • Recent
  • Answers
  • Bheem

    How to deploy oracle apex app in oracle SaaS

    • 0 Answers
  • Rameez Tariq

    How to create View with Blob column through DBLINK

    • 0 Answers
  • Huy Nguyen

    Dynamic action on column on Interactive Grid

    • 3 Answers
  • GudDud

    Load PDF into APEX, Edit it and Print it.

    • 0 Answers
  • Huy Nguyen
    Huy Nguyen added an answer Thank you for your good idea. March 5, 2021 at 12:09 pm
  • Vinish
    Vinish added an answer Oh, this will work for only new rows. For existing… March 5, 2021 at 11:22 am
  • Vinish
    Vinish added an answer I think you do not need to create the dynamic… March 5, 2021 at 11:14 am
  • Vinish
    Vinish added an answer Are you converting your CLOB to varchar2 in the report?… March 5, 2021 at 6:56 am
  • Vinish
    Vinish added an answer You can reduce the number of column span for the… March 4, 2021 at 7:53 am

Recent Blog Posts

  • Vinish

    Oracle Apex - Display External File in Region

  • Vinish

    Oracle PL/SQL Download BLOB File to Disk

  • Vinish

    Oracle Convert External File to BLOB

  • Vinish

    Oracle Apex Calendar Example

  • Vinish

    Oracle Apex - Open Modal Dialog Page Using JavaScript

Explore

  • Home
  • Blog
  • New Questions
  • Tutorials
    • Oracle
    • Oracle Apex
    • Python
  • Tags
  • Users
  • Badges & Points
  • About

© 2021 OrclQA.Com. All Rights Reserved. Privacy Policy