Specifications

Configuring the PlantScape ODBC Driver
PlantScape Server and Client Configuration Guide 413
Building a History Query
The format for history queries is slightly different from other queries because the
names of points are system-configurable.
To build a query which retrieves the 5-second snapshot values of your sinewave
point over a 10 minute period:
1 Select the Queries tab.
2 Click New, select Design View and click OK to display the Show Table
dialog box.
3 Select History5SecSnapshot, click Add, then close the dialog box.
4 In the first row/first column click the left mouse button and select
TimeStamp from the drop-down list.
In the Criteria row add:
> 8:30 24/5/98 AND < 8:40 24/5/97
(using the actual timespan of your choice)
5 In the second column select Parameter001.
In the Criteria row add:
=’sinewave.PV’
6 In the third column select Value001.
7 In the fourth column select Quality001.
8 Select View
⇒
Datasheet to send the query to your PlantScape database.
Using PlantScape ODBC Driver and Microsoft SQL Server
This section assumes that you have already completed the installation and
configuration of your PlantScape system with the ODBC driver.
It assumes that you have:
• Installed the PlantScape Server software
• Installed the ODBC Client software on a client computer
• Configured a data source on the client computer
• Installed Microsoft SQL Server on the client computer
• Started the PlantScape system on the server computer
plscpcg.book Page 413 Monday, May 28, 2001 10:11 AM