Solved

Avoiding System Messages !!

Posted on 2001-07-14
5
1,141 Views
Last Modified: 2011-09-20
Hi there !!!

Whenever I save a record in my form (D2k Forms 5.0) the message "2 records commited and posted" appears. Whenever I perform a query and there are no records meeting that criteria, the message "Query caused no records to be retrived" comes.

What should I do to avoid this messages ? In short how can I stop the system messages from getting displayed ?

One more thing. If I want to display a line of text on the status bar of my form at runtime like "Press F5 for calculator" etc. How can I do it ? and this line should remain there till my form is running without disappearing for any reasons.

Regards,
Rocky.
0
Comment
Question by:rocky_cruise
5 Comments
 
LVL 1

Accepted Solution

by:
bkm earned 50 total points
Comment Utility
Rocky,

You can use the system variable SYSTEM.MESSAGE_LEVEL to
display the messages depending on its severity.  

SYSTEM.MESSAGE_LEVEL represents one of the following message severity levels: 0, 5, 10, 15, 20, or 25. Default is 0.

During a Runform session, Oracle Forms suppresses all messages with a severity level that is the same or lower (less severe) than the indicated severity level. Oracle Forms does not suppress prompts or vital error messages, no matter what severity level you select.

Assign a value to the SYSTEM.MESSAGE_LEVEL system variable with standard PL/SQL syntax:

:System.Message_Level := value;

If you want to suppress which are not very severe, set
:SYSTEM.MESSAGE_LEVEL := 25;

Regarding the text you want to display on the status bar, you can use the built-in MESSAGE('This is a test message') built in.  But this is not the choice if you want to display something all the time.  You might have to use a display item and make it look like the status bar and then set the value of this display item.

Hope this helps!!
0
 
LVL 1

Expert Comment

by:saschek
Comment Utility
Additional hint:
If you want to supress or customize only certain (or all) messages you can do this in ON_ERROR and ON_MESSAGE triggers no matter how severe they are.
(Im using both, triggers and SYSTEM.MESSAGE_LEVEL of 5 or 10.)
-- Sven
0
 
LVL 6

Expert Comment

by:Mindphaser
Comment Utility
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
LVL 49

Expert Comment

by:DanRollins
Comment Utility
Recommended disposition:

    Accept bkm's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Expert Comment

by:Moondancer
Comment Utility
Thanks, Dan.
I finalized this today and will monitor it in the event an adjustment is needed.
Moondancer - EE Moderator
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle SQL Select Statement 19 58
Oracle TEXT search question 9 26
PL/SQL - Leading zeros 7 39
Error executing command from server 6 24
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now