You have a form that called a database stored procedure. You do not want processing to continue, so immediately after the call to the stored procedure, you add the following code:IF NOT FORM_SUCCESS THEN -MESSAGE ('Stored Procedure failure');RAISE FORM_TRIGGER_FAILURE;END IF;You test the code and input some data that intentionally causes the stored procedure to fail. However, the message that you defined does not appear. What are two possible reasons for this?
You want to use the Forms Debugger to diagnose a problem with the RAISE_STATUS program unit that is stored in the database.Forms Builder, you set a breakpoint in the stored code, and then run the Human Resources form in debug mode. You click the Raise_Salaries button, which has aWhen Button Pressed trigger that calls RAISE_SALARIES.However, you are unable to see the RAISE_SALARIES procedure when you step through the code, and it does not appear in the stack frame. What could be the reason for this problem?
View the Exhibit.You have integrated the WebUtil utility into the Orders form. You code a When-Button-Pressed trigger to call some WebUtil functionality, and then run the form to test it. Everything works as it should.You then write some other triggers and test the form again. Before the form appears, you receive several errors that are similar to the one shown in the Exhibit.What is a probable cause of this error?
View the Exhibit.The DBA has added a 30-character Cust_Middle_Name field to the Customers table and wants you to add it to the Customers form. It should be on the same line as the as the first and last names, which are on the Name tab page of the Tab_Customer canvas that appears in the Layout Editor as shown in the Exhibit. TheTab_Customer tabbed canvas is displayed on the Customer_CV content canvas as shown in the Exhibit.What must you do to accommodate the additional label and text item and to display the middle name?
View the Exhibit.The Summit menu is attached to the Orders form. The Toggle Autoquery menu item is a check box that toggles whether a query is automatically performed when the Orders form is first invoked. If the check box is deselected, users must manually query.In addition to using the menu, users want to be able to toggle the autoquery preference directly from the form. You add a button named Toggle Autoquery with the following When-Button-Pressed trigger:DECLARE -mi_id MENUITEMS;BEGIN -mi_id ;=FIND_ITEM ('Preferences.AutoQuery')/* Determine the current checked static of the AutoCommit menu checkbox itemAnd toggle the checked state*/IF GET_ITEM_PROPERTY (mi_id, CHECKED) = 'TRUE' THENSET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_FALSE);ELSE -SET_ITEM_PROPERTY (mi_id, CHECKED, PROPERTY_TRUE);END IF;END;However, the trigger does not compile. What three changes must you make so that the trigger compiles successfully?
The Credit_Rating item in the Customers block of an Order Entry form must be restricted to three possible values: Good, Poor, or Null (the latter value indicates that the credit rating has not been determined). Order entry clerks must be able to update this item to any of the preceding three values.You want to change the item to a check box labeled "Credit Risk" that should be selected if the customer has poor credit, the check box should not be selected if the customer's credit rating is good or undetermined.You change the item type to Checkbox, set other properties as shown in the Exhibit, and then run your form and insert three records: two with good credit and the check box deselected, and one with poor credit and the check box selected. You commit the data and query the records, with the following result set:The first two records show an undetermined credit rating, although your intention was to set the value to Good for these customers. What change must you make in the properties of the Credit_Ratinq item to enable values of Good, Poor, and Null to be entered?
