❇️ 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 pass selected value to particular column
goto150
Maybe this will help you. Revert change for unselected
Primary/Foreign Key Error which
goto150
... But if you really want to go with custom error handling function, it is enough if you copy Example of an Error Handling Function from Oracle Doc here : Documentation and use it as described in one in your earlier post in this theread. In Oracle doc it's explain in details how to adjust it and whRead more
Primary/Foreign Key Error which
goto150
Hi Hussain, I have this simple FORM on page 61 with DELETE button triggering Delete process: BEGIN DELETE FROM DEPT WHERE DEPTNO = :P61_DEPT_DEPTNO; END; :P61_DEPT_DEPTNO is page item labeled Dept Deptno here in the screen and you may see that while trying to fire Delete process I get standard errorRead more
How to check if the entered value does not already exist in Oracle Apex?
goto150
Interactive Grid. Solution that I used to find duplicates among newly entered records for the MGR field I wanted to keep unique. Right click on the MGR column and select Create Validation. Type = Function Body (returning Boolean) Language = PL/SQL PL/SQL Function Body: declare ln_count number :=0; bRead more
Primary/Foreign Key Error which
goto150
I was rather thinking of something like... I have a page item called P10_Serial_Number of Text type and I let user to edit it. My table Products, I insert P10_Serial_Number to, accepts only unique values for the SN field... Is there a way to customize an error message in case unique constraint is brRead more
How to add one column data to another column in same row in Interactive Grid on oracle apex when select row@selector?
goto150
You just need to remember that what this code actually does is with every selection change it loops through all the records and: IF see selected it set collection = service charge. (even if collection was modified by user it will still be replaced with service charge with next selection change deteRead more
How to add one column data to another column in same row in Interactive Grid on oracle apex when select row@selector?
goto150
I have a feeling that you disliked my idea of using Action button:) Maybe this piece of code is going to serve your need. Revert changes for deselected row: var view = apex.region("SID_COLLECTION_LIST").widget().interactiveGrid("getViews","grid"); var model = view.model; var selectedRecords = view.gRead more
Primary/Foreign Key Error which
goto150
It would be easier if you were more specific about the case you're dealing with.
Master Detail View(Report Total is not appearing)
goto150
Check template that is used for your page item, you'll find it in Appearance section. Your label may disappear for instance if you have your template = Hidden and and Label Column Span for this Page Item is 0.
Primary/Foreign Key Error which
goto150
Try validations.