Rice Lake 920i USB Installation Manual V5.05 - Manual (Page 112)

106 920i Installation Manual
You should determine the number of records currently
in the database both prior to and after sending the
DB.DATA command to verify that the correct number of
records are received. The number of records can be
determined with the
DB.SCHEMA command.
Note
The 62K of onboard (slot 0) memory can be
allocated to up to eight auxiliary databases.
However, the size of any one database may
limit the size and number of other databases.
DB.SCHEMA
The DB.SCHEMA command is used to get or set the
structure of a database.
DB.SCHEMA.n#x<CR>
The 920i responds to the command above by returning
the following:
<Max Records>,<Current Record Count>,
<Column Name>,<Data Type>,<Data Size>,...<CR>
The <Column Name> , <Data Type> , and <Data Size>
elements repeat for each column in the database.
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 field:
Table 10-17. Data Type Field Codes
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
The <Data Size> value must match the data type. A
range of data size values is allowed only for the
string data types:
Table 10-18. Data Size 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
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.