Specifications

20 – Using PlantScape Data in Other Applications
404 R400
Event Tables
All PlantScape events displayed in the Event Summary can be viewed through the
Event table (Figure 20.6, “Event Table Data” on page 404). Like the point tables,
the Event table can be opened and viewed directly from most client applications.
The following query, created in Microsoft Access, selects all events on the point
Sinewave and displays only the time of each event, the event type and level, and
the value of the point at the time of the event.
The same query in SQL is:
SELECT LogTimeStamp, PointID, EventType, EventLevel,
Value
FROM Event
Figure 20.6 Event Table Data
Figure 20.7 Select Query Dialog Box
plscpcg.book Page 404 Monday, May 28, 2001 10:11 AM