Specifications

Configuring the PlantScape ODBC Driver
PlantScape Server and Client Configuration Guide 405
WHERE (PointID=’sinewave’)
Note • If no value is specified for LogTimeStamp, then, by default, only events
generated within the last 24 hour period are returned.
History Tables
Nine history tables from the PlantScape database are visible via the ODBC driver.
These are:
• History1HourAverage
• History1HourSnapshot
• History1MinSnapshot
• History24HourAverage
• History24HourSnapshot
• History5SecondSnapshot
• History6MinAverage
• History8HourAverage
• History8HourSnapshot
Unlike most other tables, history tables cannot be opened and viewed directly.
You need to build a query that specifies the point (or points) whose history you
are interested in. The first columns in a history table are shown below. All history
tables have the same columns.
To specify the point whose history you are trying to retrieve, you must set
ParameterXXX to equal the point ID and parameter.
Figure 20.8 History Table List
plscpcg.book Page 405 Monday, May 28, 2001 10:11 AM