Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex - Difference between insert and update

catalpaJan 24 2020 — edited Feb 1 2020

pastedImage_0.png

This is my report/form. When I click the edit button on the left or click the Create button, they both go to the same form that allows the ability to create a new record or edit the existing record. Is there something I can use in PL/SQL to reference the difference between insert and update? I would like to do something like this:

If :Form_state='INSERT' then

validate_ins_proc;

end if;

Or, is there something I can do so when the user clicks the Edit or Create button on this form, when it goes to that next form, I can make my U/M field display only, but if the user clicked Create, then the U/M field will be editable?

Please advise. Thank you.

Comments
Post Details
Added on Jan 24 2020
3 comments
699 views