Dynamic View Suffix

A single Data Table can have more than one row layout. This is achieved by using an extra field in each row. This field, called the Dynamic View Suffix, can be 1-8 characters in length.

When tablesONLINE processes a row containing a Dynamic View Suffix, it checks the value in the Dynamic View Suffix field against the last characters in the View name to determine whether the current View applies to the row. For example, if the suffix was 02 and the View name was TABLE02, the current View would be applied to the row. If the View name was TABLE03, the View would not be applied to the current row. Using the Dynamic View Suffix, there may be a different View for each row with a different dynamic suffix value.

To define a table with different row layouts, an extra field must be added to the rows that require a Dynamic View Suffix. This field must be in the same position in every row. If the specified View exists, it defines the data in the row. If not, tablesONLINE attempts to use the View whose name is generated from the Data Table name. This View is also used if the value of the Dynamic View Suffix is a blank.