4-17
Remote Control
Reading the Measurement Results
Figure 4-2. Relationship between the three tables of the results.mdb database.
First, open the results database with the following lines of code:
Private m_dbResults As Database
dbPath = txtDBPath & "\Results.mdb"
' Open the results database
Set m_dbResults = OpenDatabase(dbPath, False, True) ' Open database as shared, read-only
The results database has three linked tables,
DUTInfo, TestInfo,
and
Parameter.
The
simplest way to handle the linkage is to create a sequence of recordsets. The
first might be accessed with something like:
sql_command = "SELECT * FROM DUTInfo WHERE sTestGroupName = 'New_Calibration' ” & _”AND
sResult = 'PASSED' ORDER BY lReportID DESC;"
Set rsReportID = dbResults.OpenRecordset(sql_command, dbOpenDynaset)
Summary of Contents for 86037B
Page 1: ...User s Guide HP 86037B Chromatic Dispersion Test System ...
Page 31: ...2 13 Operation The Main Window Figure 2 4 Repeat Measurement Selector ...
Page 72: ...3 16 Normalization Setting Normalization Preferences ...
Page 94: ...4 22 Remote Control TES Parameters Main chromatic dispersion screen ...
Page 100: ...4 28 Remote Control TES Parameters CD and Gain Measurement Settings Dialog Box ...
Page 102: ...4 30 Remote Control TES Parameters Length Measurement Settings Dialog Box ...
Page 104: ...4 32 Remote Control TES Parameters Normalization Settings Dialog Box ...
Page 106: ...4 34 Remote Control TES Parameters New Normalization Button Dialog Box ...
Page 120: ...4 48 Remote Control Output Parameters ...
Page 158: ...5 38 Maintenance Hewlett Packard Sales and Service Offices ...
Page 170: ...6 12 Installation Installation ...
Page 174: ...7 4 Reference Theory of Operation Figure 7 3 HP 86037B Block Diagram Options 121 and 122 ...
Page 175: ...7 5 Reference Theory of Operation Figure 7 4 The HP 86037B Option 114 block diagram ...
Page 190: ...7 20 Reference System Options ...
Page 191: ...8 Specifications 8 3 Regulatory Information 8 7 Specifications and Regulatory Information ...
Page 204: ...Index 6 Index ...