National Instruments BridgeVIEW 用户手册

Appendix B

Citadel and Open Database Connectivity

B-7

•

Retrieves an oven’s temperature set point and value at 3:00 p.m. and
shows the highest, lowest, and average temperatures between 2:00
p.m. and 3:00 p.m.

SELECT LocalTime, "OVEN1_SP", "OVEN1_PV",

"Max{OVEN1_PV}", "Min{OVEN1_PV}", "Avg{OVEN1_PV}"

FROM Threads

WHERE LocalTime >= "14:00"

AND LocalTime < "15:00"

AND Interval = "1:00:00"

Queries Using Specific Applications

The following sections include information on queries using specific
applications.

Using Microsoft Query with Citadel

Note

The exact operation of Microsoft Query might change from version to version.
Look in the online help for Microsoft Query for how to connect to an ODBC Data
Source for the exact instructions for your version of Microsoft Query.

Microsoft Query is a graphical data retrieval tool supplied with Microsoft
Office and Microsoft Excel. It allows you to build your SQL statement
using interactive dialog boxes. Let’s step through a somewhat involved
example to show you a few simple tricks.

To activate MS Query, double-click the MS Query icon, typically found in
the MS Office program group. If you cannot find the icon, look in

C:\

Program Files\Common Files\MicroSoft Shared\MSQuery\

Msqry32.exe

. MS Query is not part of an MS Office standard installation,

so if you do not find it on your system, install it from your MS Office disks.

Choose File»New Query… to begin and select the data source you have
setup for your Citadel historical directory as shown here. You might need
to press Other… to access a list of data sources to select.