Users do not want to see the “Working” message while a long query completes.
You are designing a form with a query that takes o long time to execute. What can you do to stop
the “Working” message from appearing?
A.
Before the line of code that executes the query, add the line:
:SYSTEM.MESSAGE_LEVEL:=’10’;
B.
Before the line of code that executes the query, add the line:
:SYSTEM.SUPPRESS_WORKING: =’TRUE’;
C.
Use the SET_APPLICATION_PROPERTY built-into set the message levelina When-NewForm-instance trigger.
D.
You do not need to do anything, the default behavior of Forms is to display the “Working”
message only if you add code to do so.
Explanation:
You can turn the ‘Working…’ message off with system.suppress_working command.
SYSTEM.SUPPRESS_WORKING examples
Assume that you want to have the form filled with data when the operator enters the form. The
following
When-New-Form-Instance trigger will prevent the unwanted updates that would normally occur
when
you fill the blocks with data.
System.Suppress_Working := ‘TRUE’;
Go_Block (‘DEPT’);
Execute_Query;Go_Block (‘EMP’);
Execute_Query;
Go_Block (‘DEPT’);
System.Suppress_Working := ‘FALSE’;