19
Application Creation
LOOKUP TABLE
A lookup table is a database file created for information reference. The lookup table provides
data to the active form when there is a match to a field in the table. The level of interaction is
dependent on the settings of the active form. The Optimizer program allows the developer to
create up to three lookup tables. A lookup table includes the following properties.
1. Lookup Table Number
2. Field Property
3. Number of fields
4. Field number
5. Offset
6. Length
7. Primary Key
8. Action when the input has no match
9. Action when the format of the record is wrong
10. Data read & upload
Figure 10
Lookup Table Number
The
Lookup Table Number
selection allows the developer to select lookup table 1 through 3.
Field property
Setting specifies whether the data field will be fixed length or have a delimiter to separate the
data. If a delimiter is specified, the developer will be required to denote the specific ASCII
code character that will serve as the delimiter. The default value is 44, which is a comma.
Using the arrow keys the developer can scroll through the values and their associated
character.
Содержание SP5500 OptimusS Series
Страница 1: ...METROLOGIC INSTRUMENTS INC SP5500 OptimusS Series User s Guide...
Страница 4: ...3...
Страница 23: ...1 METROLOGIC INSTRUMENTS INC Optimizer User s Guide...
Страница 24: ...2...