Creating a Table Variable

When you create a new table variable, it gets created in all versions of a program. Table variables can be added to both standard and templates programs. There is no limit to the number of variables that can be created for a program.

  1. To create a universal variable, select the universal icon under the project where you want to create a variable on Program Explorer. Click New, select Table and then select Table Variable. To create a global or local table variable, enter the program details tab from the program where you want to create a variable. In the top bar menu, select New, select either Globals or Locals, select Table and then select Table Variable.

Creating a Table Variable

Creating a Table Variable

  1. Enter in a name. Alphanumeric characters are permitted, but no special characters (ex: &, *, ", +, @, etc.) are allowed. In the case of linked variables, each variable has a unique name. If the naming standard is mandatory, an error message is presented if your entry does not follow the pattern. Correct your entry and try again.
  1. Select the type of data associated with the variable. Options are:
  • Integer
  • String
  • Decimal
  • Date

In the case of linked variables, a different data type may be set for each. If disabled by the system administrator in the configuration file, the data type cannot be changed for any existing variables.

  1. Set the default value of the variable. The Default Value must match the data type selected and the field is limited to 50 characters. 
  1. Select the working category.
  1. In the Variable Selection Criteria area, select an available variable from the drop down menu and double-click it. This adds it to the variable selection criteria area. You can enter up to 50 criteria.
  1. Check the filter rule option to add a filter rule. See Adding Filter Rules for more information.
  1. If you want to apply a mask, click the mask No Mask Applied Icon icon. See Masking for more information.
  1. Check the wildcard box for any variable where you want the system to accept any passed criteria. See Wildcard for more information.
  1. Check the interpolate box if you want to use interpolation to determine the correct value for the table variable. See Interpolation for more information.
  1. Click Save to save your work.

 

Adding a Field Variable

A new field variable can be created while entering or editing a table variable without leaving the Edit tab.