GSE 672 - Print Database Errors; Upload New

Macros
9-128 Chapter 9
%
%
y
y
P
P
r
r
i
i
n
n
t
t
D
D
a
a
t
t
a
a
b
b
a
a
s
s
e
e
E
E
r
r
r
r
o
o
r
r
s
s
Syntax Print Database Errors
15 [ , dbase# ] [ ; comm ] %y
Arguments
dbase# Database number (1 → 250).
comm Communication port (1 → 4).
Notes
Omitting dbase# assumes database last accessed. If no databases have been accessed,
the first defined database is assumed.
Omitting comm assumes port 1.
Print Database Errors
Prints database rows containing corrupted data. This is a diagnostic tool used to check the integrity of
stored data. A checksum is stored with each row of a database. Each time the row is accessed, the data's
checksum is recalculated and compared with the stored checksum. If the checksums do not match, the data
is considered corrupt.
The print format is similar to the %y Print Database command, beginning with a header line identifying the
columns, followed by corrupt rows and ending with a summary of the number of corrupt rows found.
%
%
y
y
U
U
p
p
l
l
o
o
a
a
d
d
N
N
e
e
w
w
Syntax Upload New
16 [ , dbase# ] [ ; comm ] %y
Arguments
dbase# Database number (1 → 250).
comm Communication port (1 → 4).
Notes
Omitting dbase# assumes database last accessed. If no databases have been accessed,
the first defined database is assumed.
Omitting comm assumes port 1.
See Also
%y Upload Update Database
%y Download Database
Upload New
Initiates the upload of new data rows to a database. New data is appended to existing data rows. Data
must be sent in a comma-delimited ASCII text format with fields matching the database structure and
column data types. Each data row must be terminated with a carriage return <CR>. The last line of the
15,3%y Transmits errors for database #3 out comm port 1.
15,4;3%y Transmits errors for database #4 out comm port 3.
15%y
Transmits errors for the last database selected out
comm port 1.
15;2%y
Transmits errors for the last database selected out
comm port 2.