Program Analysis

The Program Compiler analyses the program to determine the order in which the various steps should be executed. The following parts of the program structure are defined:

Analysis Process
When to access the database The record is accessed when all the key fields are set up. A key is set up by any of the following methods:

  • The key fields are defined in the field processing
  • The keys are set up in a parent that has already been defined
  • The user enters values into the key fields
Depth to use for searches This is set to the number of keys that can change during the search. Fields that stay the same are those which are copied from the parent table, or are assigned in a formula that is "Applied always"
Point to go back to when a validation fails If a validation fails, the cursor returns to the first key field