You do not want users to execute queries while in the Order_Items block, so you write the following key-Exeqry trigger for the Order_Items block:
GO_BLOCK('orders');
EXECUTE_QUERY;
This works fine except that in the Order_Items block, when you click Enter Query first, and then click Execute Query, you get the error message ''FRM-41009: Function key not allowed.'' What can you do correct this?
The Orders form has three blocks: Orders, Orders_Items, and inventories. It also has a button labeled Next Block with a When-Pressed trigger.
IF :SYSTEM.cursor_block = 'orders' THEN
GO_BLOCK('order_items');
ELSIF :SYSTEM.cursor_block = 'order_items' THEN
GO_BLOCK('inventories');
ELSIF :SYSTEM.cursor_block = 'inventories' THEN
GO_BLOCK ('orders');
END IF;
The button is not functioning correctly; it does not cause navigation to occur. What must you do to fix the issue?
Which setting of :SYSTEM.MESSAGE_LEVEL suppresses all system messages?
Controlling System Messages
You can prevent system messages from being issued, based on their severity level. FormsBuilder classifies every message with a severity level that indicates how critical or trivial the information is; the higher the numbers, the more critical the message. There are six levels that you can affect.
Note: Suppressing Messages According to Their Severity
In a trigger, you can specify that only messages above a specified severity level are to be issuedby the form. You do this by assigning a value to the
MESSAGE_LEVEL
system variable. Formsthen issues only those messages that are above the severity level defined in this variable.The default value for
MESSAGE_LEVEL
(at form startup) is 0. This means that messages of all severities are displayed.
The Orders application enables the Orders form to be opened from the Customers form. Users are confused because when they save a new or changed order, they sometimes receive an error message that indicates that no changes have been made.
What could be the possible cause of this problem?
You want to display fields of a form module on multiple layouts that are visible simultaneously, what can enable you to achieve this?
Currently there are no comments in this discussion, be the first to comment!