Specifications

20 – Using PlantScape Data in Other Applications
410 R400
7 A number of dialog boxes titled Select Unique Identifier appear. Click OK in
each dialog box without selecting any items.
Note These dialog boxes refer to a feature that is not supported by the
PlantScape server. Changing anything in any of these boxes can lead to
unpredictable results.
You have now created links to all the tables in the database. The table names and
icons should be visible when the Tables tab is selected.
Step 2. Viewing Tables
Most tables can be viewed without writing a specific query. For example, you can
click the Event table to retrieve and display events from the last 24 hours.
All tables except the History and ControlModulePoint tables can be opened in
this manner.
Step 3. Designing a Simple Query
The following queries assume you have built a system sinewave point (called
sinewave) on your PlantScape system that:
• Generates high and low alarms
• Is configured to collect fast history
To do this:
1 Start up Quick Builder and open a new project.
2 Add a channel, select the channel type UserScanTask.
Note You must be licensed for user scan tasks to build a channel of this
type.
3 Add a controller, choosing the controller type UserScanTask, and set:
• The channel name to that of the channel you just created
• The file number to 8
• The record number to 1
Figure 20.11 Event Table Viewed in Access
plscpcg.book Page 410 Monday, May 28, 2001 10:11 AM