41
Chapter 3 Lookup
3.6 (MAX) LENGTH
When the field property is set Fixed Length, specify the length for each referred
data field. The value can be 255 at most.
When the field property is set Delimiter, specify the maximum length for each
referred data field. The value can be 255 at most.
Note: If a delimiter is used to separate data fields, any improper value would cause
wrong data format.
3.7 KEY FIELD
The import of data depends on the key field. Select your key field so that an index file
can be created for the database (lookup file).
When a form makes reference to a lookup file, there must be one input field
associated with the key field of the database (lookup file).
When its input data is found matching with that of the key field, data of other input
fields, if referring to a lookup field, will be imported accordingly.
If no matching, see section
3.4 Action When the Input Data Has No Match.
Note: If offset and length of each field are specified improperly, it may go wrong with
data import.
3.8 ACTION WHEN THE FORMAT OF RECORD IS WRONG
This applies to Delimiter, when a delimiter is used to separate data fields of the lookup
file. It provides several options to handle wrong data format when you download the
lookup file to the mobile computer.
3.8.1 STOP THE DOWNLOAD PROCESS
When wrong data format is encountered, a warning message will be displayed on the
mobile computer to indicate which line is found format mismatching. The downloading
process is stopped then. You will need to correct the data format, for example, remove
an empty record (line) at the end of a file. Then, download the lookup file again.
To Next Page
Loading...