If systemformstatus changed then commitform end if

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: IF :SYSTEM.FORM_STATUS = 'CHANGED' THEN COMMIT_FORM: END IF; GO_FORM('CUSTOMERS'); Answer: A Oracle Forms Developer 6i: Build Internet Applications II M9-P17 QUESTION 5: Your company assigns three possible credit ratings to customers: Poor, Good, and Excellent (represented numerically by 1, 2, and 3). The DBA has just added a RATING column to the CUSTOMERS table and has asked you to add an item to your form so that data entry clerks can populate the RATING column. To restrict data entry clerks to one of these three values, you decide to create a radio group for the Rating item. With the Customers block selected in the Layout Editor, you use the radio button to create three radio buttons on the canvas. You then set the labels (Poor, Good, and Excellent) and values (1, 2, and 3) for the radio buttons. You set the name of the radio group to RATING, its Data Type to Number, and its Database column to Rating. You run the form to test it. When you execute a query, however, no records are returned, although there are many customer records in the database. What can you do to make the query return the records? A. Set the Mapping of Other Values property for the radio group to Null. B. Create a fourth radio button for an undetermined credit rating and leave its value blank. C. Create a fourth radio button for an undetermined credit rating and explicitly set its value to Null. D. Choose a different type of input, because radio groups do not allow query of Null values. Answer: A Oracle 9i: Forms Developer Build Internet Application M8-P23 Handling Other Values in a Radio Group If the base table column for a radio group accepts values other than those associated with your radio buttons, you must use one of the following methods to specify how you want to handle the values: Actualtests.com - The Power of Knowing 1Z0-141 Ignore other values (by leaving the radio group's Mapping of Other values property blank) Associate the other values with one of the existing radio buttons (by naming the associated value of the button in the Mapping of Other Values property) Note: Ignoring other values results in the entire row being ignored during query processing....
View Full Document

Ask a homework question - tutors are online