Translation Configurator usage

The Database Lookup option in the Lookup Table Configurator uses the TABLE action to do the lookup:

  • The table uses column name and value address mapping.
  • Multiple sources to multiple destinations is supported.

When the selected table configuration is a database and it has multiple In/Out columns, the corresponding source/destination list display as a table component.

The table has two columns:

  • Input name/Output name

    These list all the column names of the In/Out fields of the .tbl configuration.

  • Format field

    This is used to fill the correspondent message format field address. All format field cells must be populated; otherwise, the GUI prompts an error message.

Double-clicking an input/output message format tree node inserts the field address into the selected format field cell.

Under the runtime, according to the source settings, the translation engine uses the value of the specified input message format field. It then replaces the placeholder in the .tbl SQL statement. It also runs it to do the database lookup.

After the result is returned, the translation engine populates the specified output format field with the corresponding output value. This is according to the destination settings to compose the output message.