❇️ 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.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
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.
Interactive Grid Revert Changes
apexgeek
Try to refresh after reverting: apex.region("PRODS").call("getActions").invoke("refresh");
Clear input field and count QR/ Barcode scanned items and save scanned items into indexed db
apexgeek
Remove the space between @ and code in the beginning.
Clear input field and count QR/ Barcode scanned items and save scanned items into indexed db
apexgeek
Try this: @ code { private int LaybyCount = 0; private string LaybyCountValue = "0"; private string InputCodeValue = ""; private string store = ""; // Assuming you have a variable for store number // Your CurrentLayby object needs to be defined here private CurrentLaybyType CurrentLayby = new CurrenRead more
How to delete multiple member from Apex collections on selection of check box
apexgeek
I have modified the code.
How to delete multiple member from Apex collections on selection of check box
apexgeek
Here's an example PL/SQL code snippet that demonstrates the deletion process: DECLARE l_member_id NUMBER; BEGIN FOR i IN ( SELECT member_id FROM your_collection WHERE checkbox_column = 'Y' ) LOOP l_member_id := i.member_id; APEX_COLLECTION.DELETE_MEMBER( p_collection_name => 'YOUR_COLLECTION_NAMERead more
By Change Page Item Focus ON IG
apexgeek
Here is a step-by-step guide to accomplish this: Create a Dynamic Action for the Page Item: First, you need to create a dynamic action that will trigger when the page item value is changed. Go to the Page Designer. Right-click on the page item that should trigger the focus change and select "CreateRead more
Oracle Apex Jasper Reports with parameter
apexgeek
To achieve the requirement where you need to first save the record (execute a PL/SQL block) and then call a Jasper report with parameters in Oracle APEX, you can follow these steps: Create a PL/SQL Process: This process will handle the insertion of the record into the database. Make sure it is set tRead more
How to save and update data into collection from Interactive grid on column such as checkbox?
apexgeek
Create a dynamic action on that checkbox for checked value and select the action Execute Server side code and there loop through collection records and insert it to a table.
Changing the background color of Cards (20.2)
apexgeek
First, determine which column in your source table you want to use for color coding. For example, let's say you have a column named Status with values like 'New', 'In Progress', and 'Completed'. You might want to assign different colors to these statuses. In your card's region source, modify the SQLRead more
Use table with DBLINK and without DBLINK PL/SQL ORACLE
apexgeek
You can increase one more parameter in your procedure to instruct when to use the db link and when not. Below is an example: CREATE PROCEDURE credit_account (acct NUMBER, new_balance NUMBER, use_dblink in varchar2 default 'N') AS BEGIN if use_dblink = 'N' then UPDATE accounts SET balance = new_balanRead more