Specifications
20 – Using PlantScape Data in Other Applications
412 R400
7
In the third column select PVValue.
8
In the fourth column select OnScan. In the Criteria row, type:
=1
(to select all the points which are currently scanning)
Unmark the check-box to prevent this column from being displayed.
9
Select View
⇒
Datasheet to send the query to your PlantScape database.
You should see a table like the one below.
Building an Event Query
To build a query that select all events in the last 24 hours that have raised urgent
alarms:
1
In the New Query dialog box, select Design View.
2
Select Event, click Add, and then close the dialog box.
3
In the first row/first column select Event* from the drop-down list.
4
In the second column select Level. In the Criteria row, add:
Like ’U*’
5
Select View
⇒
Datasheet to send the query to your PlantScape database.
By default, the ODBC driver retrieves events over the last 24 hours. If you want to
retrieve events over a specific period of time:
1
Select LogTimeStamp from the next free column.
2
In the Criteria row, add:
> 8:30 24/5/98 AND < 15:30 24/5/98
(using the actual timespan of your choice)
Figure 20.13 Results of Query on Analog Point Table in Access
plscpcg.book Page 412 Monday, May 28, 2001 10:11 AM