:system.message_level :=25 not working.
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