Rice Lake 920i Installation Manual V1.05 - Manual (Page 85)

Serial Commands 81
The <Column Name> follows the rules for alias
names: 8 character maximum; must begin with an
alpha character or an underscore; can only contain
AÐZ, aРz, 0Р9, or an underscore (_).
The
<Data Type> is represented by a numeric Þeld:
The <Data Size> value must match the data type. A
range of data size values is allowed only for the
string data types:
The DB.SCHEMA command can also be used to modify
the schema, but only when the indicator is in setup
mode and only if the database does not contain any
data.
Value Type
1 Byte
2 Short (16-bit integer)
3 Long (32-bit integer)
4 Single (32-bit floating point)
5 Double (64-bit floating point)
6 Fixed string
7 Variable string
8 Date and time
Table 9-14. Data Type Field Codes
Size Value
Byte 1
Short 2
Long 4
Single 4
Double 8
Fixed string 1–255
Variable string 1–255
Date and time 8
Table 9-15. Data Size Field Codes