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!

:system.message_level :=25 not working.

Hassan R. KhanDec 20 2006 — edited Dec 20 2006
Dear All:

I am using Developer 6i 6.0.8.23.2.
I have created a tabular to enter data. Form contains following fileds:
Area_Id, Area_Description, Working_Person
I have to validate the Area_Id whether the entered value is already exists in Database or in the form (when user enter multiple record and commit in the end),

I use post on WHEN-NEW-RECORD-INSTANCE for this purpose. I also want not to display the message FRM-40404: Database apply complete: 1 records applied. I use system.message_level for this purpose. I wrote following coding on WHEN-NEW-RECORD-INSTANCE.

:SYSTEM.MESSAGE_LEVEL := 25;
post;
:SYSTEM.MESSAGE_LEVEL := 0;

When I Run form from Form Run Time it works fine, but when I execute this form from Menu and press execute query button or enter multiple records system always return FRM-40405: No changes to apply.

I have not use system.message_level in my Menu file (.mmb) so there is no chance to over write the execution sequence.

Can anyone help me?

Thanks

Hassan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2007
Added on Dec 20 2006
2 comments
926 views