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.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Showing Return value in Interactive grid column
Farooq Ahmad
Hi See You Have PO_detail Table and GRN_DETAIL now you will have PO_NO in GRN_Detail so use not in query in where clause and get by pl sql curser
Hi See You Have PO_detail Table and GRN_DETAIL
now you will have PO_NO in GRN_Detail so use not in query in where clause and get by pl sql curser
See lessRate doesn't take from database when query/Item selection
Farooq Ahmad
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 lessRun Oracle RDF Report from Oracle Apex 20.1
Farooq Ahmad
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
See lessDynamic Action Redirect To Another Page in Oracle Apex
Farooq Ahmad
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 lessHow to Open any Window Program (Paint/Calculator)
Farooq Ahmad
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 lessDeveloper Suite with windows server 2019
Farooq Ahmad
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 lessInline Dialog Refresh before opening
Farooq Ahmad
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:
I hope I explain it well.
See lessDeveloper Suite with windows server 2019
Farooq Ahmad
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 lessDisplay Image in Interactive Grid Report Apex 20.1
Farooq Ahmad
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 lessDisplay Image in Interactive Grid Report Apex 20.1
Farooq Ahmad
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