×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You are developing a Human Resourced form with a single block to display employees. For each employee, you look up the department name to display in a non-base-table item.
When you test the form, you discover that when you enter a new employee as the first employee in a new department that has not yet been created in the database, you get the following error when you try to navigate
out of the Department_Id item: FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-
01403.
The ORA-01403 exception is the NO_DATA_FOUND exception. When this message is received, you cannot
navigate out of the Department_Id item.
You add the following code to the When-Validate-Item trigger on the Department_Id item to display a
meaningful message to the use:
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE('You must create the department before adding employees to it');
You run the form again to test it, and you enter a new employee and a department ID that does not exist in the
database. When you click into the Employee_Name Item, the appropriate message is displayed, but the cursor
moves to Employee_Name.
What must you change so that the user will not be able to navigate out of the Department_Id item when
entering a department ID that is no in the database?
When you test the form, you discover that when you enter a new employee as the first employee in a new department that has not yet been created in the database, you get the following error when you try to navigate
out of the Department_Id item: FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-
01403.
The ORA-01403 exception is the NO_DATA_FOUND exception. When this message is received, you cannot
navigate out of the Department_Id item.
You add the following code to the When-Validate-Item trigger on the Department_Id item to display a
meaningful message to the use:
EXCEPTION
WHEN NO_DATA_FOUND THEN
MESSAGE('You must create the department before adding employees to it');
You run the form again to test it, and you enter a new employee and a department ID that does not exist in the
database. When you click into the Employee_Name Item, the appropriate message is displayed, but the cursor
moves to Employee_Name.
What must you change so that the user will not be able to navigate out of the Department_Id item when
entering a department ID that is no in the database?
2.
You are testing a form.
How can you programmatically disable validation during testing?
How can you programmatically disable validation during testing?
3.
The following On-Error trigger was written to give users a more meaningful message when they press the Up key when the cursor is in the first record (the FRM-40100 error) and to display default messages for all other
errors: IF message_code = 40100 THEN
MESSAGE('You are already at the first record');
ELSE
MESSAGE(message_type || '-' ||
to_char(message_code) | '-' || message_text);
END IF;
When you test the form, you still get the FRM-40100 message when you press the Up key while the cursor is in the first record. Your custom message does not appear.
What correction can you make so that the code functions properly?
errors: IF message_code = 40100 THEN
MESSAGE('You are already at the first record');
ELSE
MESSAGE(message_type || '-' ||
to_char(message_code) | '-' || message_text);
END IF;
When you test the form, you still get the FRM-40100 message when you press the Up key while the cursor is in the first record. Your custom message does not appear.
What correction can you make so that the code functions properly?
4.
You are writing a Forms application, and you plan to include several JavaBeans.
What should you do to facilitate the communication between Forms and the JavaBeans?
What should you do to facilitate the communication between Forms and the JavaBeans?
5.
Order entry clerks use the Orders form to enter the shipping date of an order. Once the shipping date has been entered into the database, the clerks are not allowed to modify it.
What property can you set in the Property Palette for the Shipping_Date item to ensure that this data entry restriction is enforced?
What property can you set in the Property Palette for the Shipping_Date item to ensure that this data entry restriction is enforced?
6.
Why would you want to create a control block in a Forms module?
7.
You want to find out if a certain menu item exists in the menu that is attached to a form, so you use the following code in a When-Button-Pressed trigger.
DECLARE
mi_id BOOLEAN;
BEGIN
MI_ID:= FIND_MENU_ITEM('File.Exit');
IF mi_id THEN
MESSAGE('The Exit menu item exists');
END IF;
END;
Is this code correct? If not, what would you need to change?
DECLARE
mi_id BOOLEAN;
BEGIN
MI_ID:= FIND_MENU_ITEM('File.Exit');
IF mi_id THEN
MESSAGE('The Exit menu item exists');
END IF;
END;
Is this code correct? If not, what would you need to change?
8.
You want to standardize the appearance of certain text items in a particular form, so you create a Visual
Attribute called TEXT_ITEM_VA and define values for all of its properties.
Which four properties can you set by applying TEXT_ITEM_VA to the items? (Choose four)
9.
You want to create a calculated item in the Control block of the Human Resourced form. This item will contain the total of employee salaries for employees in a particular department.
Which statement is true about how to create the calculated item?
Which statement is true about how to create the calculated item?
10.
What is an indication that the Data Block Wizard is in reentrant mode?