20
Application Creation
Lookup Table properties (cont.)
Number of fields
Setting specifies the number of fields in the lookup table.
Field
The position of the field in the lookup table that is being defined.
Offset
The Offset setting value identifies the start position for particular field of the lookup table. It
is important to note that the total value of the Offset and the Length settings can be no
greater than 255.
Length
The Length setting specifies the length of the field in the lookup table. It is important to note
that the total value of the Offset and the Length settings can be no greater than 255.
Primary Key
References field in a lookup table to populate all other fields in a record if there is a match.
Action when the input has no match
Setting determines the appropriate action to be taken when the input data does not have a
match in the lookup table database. The default setting is continue, meaning the program
will proceed to the next input field without showing any message. The following are the
available actions to be taken.
1. Continue
2. Show warning message
3. Insert to lookup table
4. Show warning message and insert
5. Clear the screen
6. Show warning message and clear screen
Action when the format of the record is wrong
Setting determines the appropriate action to be taken when the table is being downloaded to
the Optimus, if the transactional data format does not match the settings specified in the
lookup table. The default is
stop the download process
, meaning that the active download
with stop. The following are the available actions.
1. Stop the download process
2. Truncate/Reformat the record
3. Skip the record
Data read and upload
Setting determines if the data can be uploaded to the host device from the terminal.
Summary of Contents for SP5500 OptimusS Series
Page 1: ...METROLOGIC INSTRUMENTS INC SP5500 OptimusS Series User s Guide...
Page 4: ...3...
Page 23: ...1 METROLOGIC INSTRUMENTS INC Optimizer User s Guide...
Page 24: ...2...