View the Exhibit.To test how the Orders application works with database triggers, you add to the Orders table the following database trigger that fires before the update ofCustomer_Id:BEGIN -If :old.customer_id != : new.customer_id thenRAISE_APPLICATION_ERROR (-20101, 'Database trigger says no!'); end if;END;You run the Orders form, change the customer ID, and click Save. You receive the error message "FRM-40509: Oracle error: unable to UPDATE record." You select Help > Display Error, and the Database Error dialog box that is shown in the Exhibit appears.Which code would you put in your Form-level On-Error trigger to display the ORA- error message instead of the FRM- error message?
To troubleshoot a problem with a form, you have added a call to the MESSAGE () built-in at the beginning of the When-Validate-Item trigger of the Customer_Id then in the Orders Block of the Orders form. The message simply states that the trigger is firing.You run the form, make a change in Customer_Id, and then tab out of the item but the message does not appear. What are two possible causes for this problem?
You have just created radio buttons labeled Outstanding, Exceeds, Meets, and Does not Meet for the employee appraisal rating, but you accidentally created it on the Employee_Training canvas rather than on the Employee_Appraisal canvas. How can you move them to the appropriate canvas?
Which type of variable must be declared before it is used in a trigger?
Which statement is true about flexible code?
View the Exhibit.You have defined the window, canvas, and text items shown in the Exhibit. What happens when click Run Form?
