GSE Scale Systems - 211
Chapter 20 Database (OPTION) Technical Reference Manual
This command is essentially like the "Upld. new"
command except that before a row is created, a search of
the database is accomplished to verify whether the row
already exists. This procedure prevents duplicate rows
from being created. However this will slow down the
updload significantly, especially for larger databases.
Thus the "Upload New" selection should be used
whenever possible for faster response.
b. An entry followed by the <ENTER> key:
An entry is not allowed before the <ENTER> key for
this selection. If an entry occurs, the "ENTRY ERROR"
message will be displayed briefly.
18 SORT DBASE:
a. <ENTER> key alone:
The "Sort DBASE" command allows the sorting of the
currently selected database. After pressing the
<ENTER> key on this selection, the unit will begin
sorting the current database based on the current column
selection, in a lowest to highest order. If an exact match
of data in the current column is found in two records,
then the SORT function automatically compares the data
in additional columns, starting with the first column and
proceeding through to subsequent columns until a non-
matching field is found. During the sort, the unit will
display a counter indicating the number of rows which
have been sorted. Pressing the <CLR> key will abort
the process. In the absence of a <CLR> key, the unit
will continue sorting until the end of the database has
been reached.
If sorting strictly numeric values, its best to put the
values in a numeric register. The numeric values will be
sorted in numerical order. Numbers placed in an ID or
data string will be sorted as a DOS sort. ie.
1
10
11
2
20
21
22
If alpha-numeric characters are to be used, a data string
or ID must be used as the sort column. The data will be
sorted in ID’s as a DOS sort. ie.
ABC-1.DOC
ABC-10.DOC
ABC-11.DOC
ABC-2.DOC
ABC-20.DOC
The "Sort DBASE" command can be very useful for
generating reports which are printed in some significant
order, other than the order in which the rows were
created. However this operation can be quite slow
depending on the number of records being sorted and
upon the current order of the records. As an extreme
example, a completely disordered database with
thousands of records could take a few hours to sort!
b. An entry followed by the <ENTER> key:
If an entry is made, then the database is sorted according
to the column whose parameter ID was keyed in. This
is simply a quicker method of requesting a sort on a
column other than the current column. It avoids having
to first use the "Set Colmn" command. Also, by entering
a period (".") before the parameter ID the sort direction
can be reversed to be from highest to lowest.
Another available feature is to sort on a secondary
column. This comes into play in cases where two rows
have identical data in the primary sort column. The
secondary sort column's parameter ID is specified in the
entry after a comma ( , ) or space ( ) following the
primary sort parameter ID. Refer to the following
examples for clarification on the method of specifying
the sort criteria.
11 <ENTER> Sorts on time / date in
ascending order. (oldest to
newest)
.11 <ENTER> Sorts on time/date in
descending order.
(newest to oldest)
.21, .11 <ENTER> Sorts on ID 1 in ascending
order. If an exact match of
ID 1 is encountered, the
matching records are sorted
according to time/date in
descending order. (newest
records first).
.21, .22, .0 <ENTER> Sorts on ID 1 in descending
order. If an exact match of
ID 1 is encountered, the
matching records are sorted
according to ID 2 in
SECTION - 20.8
To Next Page
Loading...