Skip to Main Content

Oracle Forms

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!

Doubt Regarding Message Alert...

AJ.MDec 13 2010 — edited Dec 13 2010
Hello,

I am very new to Oracle Forms & i am using Forms 6i.

As i am practicing some basics like 'Validating' a text-item i have gone through some sample code for bringing or poping-up alert messages...

Below is my Code ... in this i dont understand Y ...do we write the " Message(' any msg ') " line TWICE ..??

Though i have Commented the 2nd one .... but y we have to write it Twice ... & wat is the Logic Behind it ...??

plz help ....

---------------------------------------------------------------------------------------------------
Begin

if (:aijaz_emp_master.em_dob > :aijaz_emp_master.em_doj) then

set_item_property('em_dob', current_record_attribute, 'VA_ERRORS');

--if (:aijaz_emp_master.em_dob is not null and (:aijaz_emp_master.em_doj > :aijaz_emp_master.em_dob)) then
message('DOB must b NULL or Greater tahn DOJ');
--message('DOB must b NULL or Greater tahn DOJ');

raise form_trigger_failure;

else
set_item_property('em_dob', current_record_attribute, 'VA_NOnERROR');
end if;

end;
---------------------------------------------------------------------------------------------------------
This post has been answered by CraigB on Dec 13 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 10 2011
Added on Dec 13 2010
2 comments
6,060 views