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?

Which statement is correct with regard to object group?

Which statement are correct with regard to Query Record Group?

In the Orders Form you define five LOVs and create one button to be used to display any of the LOVs. The button is enabled only when the user navigates through a field with an attached LOV. If the user supplies only a part of the required input data, LOVs use that input as search criteria to automatically reduce the LOV Contents. If the LOVs hold only one value that can possibly match user-supplied input, the LOVs auto-complete the input field and are not displayed. Which built-in properties should be used to display the LOVs?

The user must be able to invoke a list of values for valid sales representative in the Orders form. To facilitate this, you created a button and positioned it next to the Sales Rep ID field The text item has these properties set: - Required: Yes - List of Values: SALES_REP_LOV - Validate from List: No The button has these properties set: - Keyboard Navigable: Yes -Mouse Navigate :Yes - Iconic : Yes - Icon Filename :list .ico An appropriate LOV (called SALES_REP_LOV) has been created and associated with the text item. An icon file (list.gif) exists in the appropriate directory. All other properties are left at their defaults. You write a When-Button-Pressed trigger at the item level with this code: LIST_VALUES; To test the form, you attempt to enter a new record. What is the run-time behavior of the form?

The Department form is a part of a multiform application that also includes the Customer and Orders forms. The Department form must include a query-based PRODUCT Record Group. You must ensure that all three forms can access the PRODUCT Record Group. Which built-in will you use to create the PRODUCT Record Group?

You are developing a form for customers to order tickets to events. There is an Event_Date item in the Tickets block of the form that has a LOV whose record group uses the following query: SELECT event_name, event_date FROM events ORDER BY event_date; In the Choose_Event block of the form, you want users to be able to select an event name into an Event_Name item. The event name will be selected from a LOV that is sorted by the name of the event. You do not want to modify either LOV or record group at run time. Which of the following statements is correct with regard to LOV and record group as specified at design time?

There is a requirement to modify the default functionality of the [Commit] key. To implement this requirement, you decide to write a Key-Commit trigger that will force validation and issue a commit if necessary. Which trigger code will achieve this?

The REGIONS non-query Record Group has two char columns. Which of the following built-ins an you use to replace any existing rows in REGIONS with the results of a query?

You are running a multiple-form application. The Customers Form invoked the Orders Form. When the Orders Form launches, it displays orders for only the active customer from the Customers form. Forms exchange data with the :GLOBAL.CUSTOMER_ID variable. The Orders Form should be restricted to orders for the current customer only the first time a query is issued after invoking the Orders form. Which built-in helps you do this by setting the ONETIME_WHERE property to refer dynamically to the GLOBAL.CUSTOMER_ID?

Which of the following statements is correct with regard to client-side validation?