Campbell Scientific LNDB LoggerNet Database Software - Manual (Page 17)

LNDB
4. Options
The Tools | Options menu item can be used to set the options for LNDB. The
following options are available:
When Tables Change
This tab allows you to determine what will happen when table definitions
change. You can choose from the following options:
Stop Storing Data
Storing data to the database for the individual table stops if
table definitions change. You must manually resolve the
change.
Archive Database Table (continue storing)
The table is automatically archived when table definitions
change. Following the archive, the database table is
automatically recreated and LNDB begins to store data into
the newly created table.
An archive consists of renaming the existing table. The new
name is chosen by attaching "_arch#" to the original name. #
is chosen by starting with 1 and increasing until a table name
is found that does not already exist.
Modify/Archive Database Table (continue storing)
When table definitions change:
New columns are added to the database table. (Previous
rows are filled with NULL.)
Old columns are orphaned. (Columns are left, new records
contain NULL.)
If any column’s process, units, or data type change the table
is archived.
Data Review Options
This tab allows you to select the number of records to be shown in
LNDB’s Data Review tab. The maximum number of records to show
is 100,000.
11