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!

creating error message in enter query mode

622131Sep 1 2008 — edited Sep 2 2008
Hello experts,
I want to create an error message in a enter query mode.Suppose i have a field dob and the data filled
in the database in this fasion 01-jan-2008.

Suppose in the enter query mode some one enter the value 01/01/2008.It is not a suitable input for the system .For this error i want to create a error message.

I have written this code

if :system.mode = 'ENTER-QUERY' then
if error_type='FRM' and error_code=40358 then
message('please enter date as 01-jan-2008');
end if;
end if;

The trigger i have used is KEY-EXEQRY.but it is not showing any error when ever i give a input like 01/01/2008.


can you please suggest what's wrong in the coding.

Regards
Anutosh
This post has been answered by 611407 on Sep 1 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 30 2008
Added on Sep 1 2008
6 comments
593 views