Hi,
How to check for Duplicate record while saving in Modal Form.
Need to check whether the same combination exists while saving, if so need to populate Error message and force user to change accordingly
Please advise
Regards
Arun
❇️ 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.
Vinish Kapoor
You can create validations on individual fields to check if that already exists. But if you need to check on a combination of fields, you can do this by creating a process before the form process. Follow these steps:
Click on the process tab and then create a process and put it before for the form save process. Then you can add your PL/SQL code to check if a record exists. The following is an example:
This will not allow the save until the error is resolved.
Aru
Thanks, That worked for me