Validating Data

The procedure in the following section shows you how to validate data to check whether three separate conditions are met. The procedure allows you to perform multiple checks on the data and return a number of different outcomes before performing the secondary action, which is to run the Validate action. As a result, the code structure follows the following format:

• Action: Select
• Invoke: Subfunction
• Subfunction: Checks the data and performs the secondary action

To validate data

1. Perform a Select action to return a set of data.
2. Invoke the CheckValidation function, to check the following:
   1. Check if field 1 is greater than field 2. If not, then set the result to False and display message A.
   2. Check if field 3 is equal to field 4. If not, then set the result to False and display message B.
   3. Check if field 5 is less than field 6. If not, then set the result to False and display message C.
3. Otherwise, set the result to True.

Execute a Validate action from within the CheckValidation function, and then insert the result from the query in Step 2 to either allow the record to be saved (True) or to return the user to the data entry (False) page.