Messages in on-error coming more than once.
sriram_aNov 19 2007 — edited Nov 19 2007Hi
Iam working in Forms 10g.
Iam over-riding on-error and on-message triggers in my form.
Assume below as my on-error code:
message(error_type || '-' || to_char(error_code));
I have a date item with below code in its key-next-item trigger.
if :blk.item1 > sysdate then
Message('greater than sydate);
end if;
if :blk.item1 < sysdate then
Message('less than sydate);
end if;
Here is my issue:
I run the form and give a negative test case for the date field, ie. enter value 'asdf' for the date field.
Now iam getting on-error fired twice and getting the error message twice. ie. am getting on-error fired as many times i refer the date item in the key-next-item trigger.
But i need to get the error only once and not twice or thrice.
Please suggest me how to solve this.
Thanks
Sriram