Step 1 Add a Rule to file iiiDepartments

Step 1. Add a Rule to file iiiDepartments

REP007 - File Validation Rules/Triggers

In this step you will review the field level validation rule defined on the iiiDeptCode field that you created in exercise REP001 - Create Fields.  (When you created the iiiDeptCode field, you copied the validation rules from the DEPTMENT field.) You will also add a rule at file level to demonstrate how these rules interact.

1.  Open file iiiDepartments in the Editor.

2.  Select the Rules and triggers tab.

3.  Expand the two existing rules to see their complete details. Notice both rules are at field level and cannot be changed using the Details tab. (You need to open the field to edit field level rules.)

     These rules state that the Department Code and the Department Description codes cannot be blank.

4.  Select the iiiDeptCode field in the list of rules to add a file level rule to it.

5.  Select Add button on the Home ribbon, and select an Add Range Check rule to the iiiDeptCode field.

6.  In the Details tab, create the rule as follows to ensure that the Department Code value has to be between A and ZZZ:

Description Dept must be A to ZZZ Sequence 1 When Inserting Always apply rule (ADD) When Updating Apply when field is used (CHGUSE) When Deleting Never apply rule From Value 'A' To value 'ZZZ'

     Your Details tab should now look like this:

7.  In the Validation Usage section, create the rule actions to set the field in error if it is not in the allowed range:

If field is in the range of values Evaluate next rule (NEXT) If field is NOT in range of values Set field in error (ERROR) Message Number (delete the entry in this field) Message File (delete the entry in this field) Message Text Dept must be in range A to ZZZ

     Your Details tab should now look like this:

     The recommended way to specify the message text is to use a message defined in a Message file as shown in Step 3. Create a Rule for the iiiSalary Field. However, for simplicity in the rest of this tutorial, you will enter the message text in the rule definition.

8.  Save the file.