APEX Forms Reloaded, Auto validation | Part 3

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.

Download application.