APEX Forms Reloaded Part 3

Auto validation Forms APEX 19 | Part 3

Preview

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

Preview

Now when you try to update or insert any row which doesn’t come under deptno 20 will get rejected.

Download application.

You might also like:


comments powered by Disqus