Looping Through Interactive Grid Oracle APEX - Part 22
In this video, you learn how to loop through each record in an interactive grid to perform some kind of validation. For example, here you will prevent addition of duplicate products in a single order. Of course, you can add a composite unique key constraint on the corresponding table to prevent duplication. But, there are some scenarios where this solution doesn’t fit. For example, if you provide some free samples of a product in an invoice, you need to create two line item entries in your order screen for the same product – one with a price tag and another free.
Topics Covered in this video:
=============================
Validation and Dynamic Action which Detects Duplicate Product records through JavaScript Code
Dynamic Action to Fetch Product Name
JavaScript function to alert about duplicate record
Data Manipulation Language Operations to check the segment
Note that this is a multi-part series and some of the topics listed below will be covered in subsequent videos and some are already covered in previous videos.
Topics Covered:
=======================
Implement master/detail forms
Sorting Interactive Report
how to save a modified interactive report
Add Control Breaks to an interactive report to group related data
Apply highlight rules to mark specific records
Using Aggregate functions
Using Chart and Group By views in an interactive report
Creating Primary, Public, and Alternative versions of an interactive report
Utilizing Copy Page utility
APEX Collection
Adding custom processes and dynamic actions
Using HTML in PL/SQL code
Using CSS on APEX pages
Download Source Code From Here:-
https://drive.google.com/drive/folder...
The content of this video is taken from my book "Create Rapid Low-Code Web Applications in Oracle APEX"
https://www.amazon.com/Create-Rapid-L...
