Auto validation Forms APEX 19 | Part 3
In our tradisional forms we have to write additional code for preventing invalid rows or putting any validation.
APEX 19 forms came up with a concept where you can define the row qualifier in query and that’s it, Form will automatically prevent the any invalid row.
Create form on below query.
SELECT * FROM emp WHERE deptno= 20;
If you see we are using where clause intentionally to showcase the auto error.
ORA-01402: view WITH CHECK OPTION where-clause violation
Now when you try to update or insert any row which doesn’t come under deptno 20 will get rejected.