HP 86037B, Instruction Manual

Page: 88 / 204

4-16
Remote Control
Reading the Measurement Results
Reading the Measurement Results
You can read results database,
results.mdb,
directly by using a variety of tech-
niques. The approach documented here uses SQL commands implemented in
a Visual Basic example program. As in the test parameter database, communi-
cation is via a network connection to the system hard drive.
You can use another database tool, such as MS Access 97, to access the test
results. Note that all access should be
read-only thus eliminating the possibil-
ity of database corruption and possible loss of data.
The one unusual aspect of the
results.mdb
database is the storage of arrays. The
structure of the
results.mdb
database can be investigated with the Visual Data
Manager add-in included in Visual Basic 5.0 Professional or any other database
tool, such as MS Access 97. The database consists of three tables. The rela-
tionship between the tables is shown in
Figure 4-2 .
The leftmost table,
DUTInfo,
contains one row for each test run. For each row in
DUTInfo
, there is a set of rows in the
TestInfo
, each of which contains information
about the tests which were executed during the run. A record set of rows from
the
TestInfo
table for a given run is created by specifying in the
WHERE
clause of
the SQL statement,
lReportID
. For each row in
TestInfo
, there is a set of rows in
the Parameter table, each of which contains information about each variable
stored in that test. A record set of rows from the Parameter table for a given
run and test is created by specifying in the
WHERE
clause of the SQL state-
ment,
lReportID
and
lTestID
. The
ReportID
is directly related to the run number of
the measurement while the
TestID
identifies the test group. More details are
given in the example file and below.