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?
Question No 2
When tabbing through items in the Employees form, users should not be able to navigate to the
Salary text item. If they need to update the item, they will have to explicitly navigate to it by using
the mouse.
Which property setting accomplishes this requirement?
Question No 3
You have a text item in your form named Object1. You want to create Object2 as an exact duplicate of
Object1. You want to be able to change the properties of Object2. However if you change Object1,
you do not want Object2 to change.
Which method of reusing Object1 would be best for these requirements?
Question No 4
The Orders form has four blocks. The Orders and Order_items block are on the CV_Order content
canvas; the inventories block items are on the CV_inventories content canvas; and Control block
buttons are on the CV_Buttons toolbar canvas. All buttons have mouse Navigate set to No.
The Order_Items block is a detail of Orders. The inventories block is a detail of Order_Items, showing
the stock of the selected product.
There is a button in the Control block with a When - Button - Pressed trigger:
IF GET_CANVAS_PROPERTY(:SYSTEM.cursor_item, item_canvas) = 'CV_ORDER' THEN
GO_BLOCK ('inventories')
ELSE
GO_BLOCK('orders');
END IF;
When you run the form and click the button, navigation does not occur, and the form displays the
runtime error “FRM - 41053: Cannot find Canvas: invalid ID.” What should you do to correct this
problem?
Question No 5
Which four types of variables must have their names preceded by a colon when they are referenced
in trigger code?