Specifications

Configuring the PlantScape ODBC Driver
PlantScape Server and Client Configuration Guide 401
To access a flexible point parameter, you set ParameterXXX to equal the
parameter you need. PlantScape then sets the QualityXXX, TypeXXX, and
TextValueXXX parameters to the corresponding values. For example, if you set
Parameter001, then Quality001, Type001, TextValue001 and NumericValue001 will
contain values corresponding to this parameter for every point.
For information about parameter names, see the relevant Point Server
documentation supplied with the Point Server software.
SQL Query on ControlModulePoint Table
The first eight columns in the ControlModulePoint table (see Figure 20.2, “Point
Data That You Can Access” on page 399) are common to all flexible points. The
other columns are user-designated parameters. To access a user-designated
parameter, set ParameterXXX to equal the parameter name. For example,
Parameter001 = PIDA.SPTVNORMRATE.
Quality001, Type001, TextValue001 and NumericValue001 will then contain
values corresponding to this parameter for every point. Below is an example
query retrieving these fields for the parameter PIDA.SP for every point on the
system.
The SQL equivalent of the above query is:
SELECT PointID, Parameter001, TextValue001,
NumericValue001, Type001, Quality001
Figure 20.4 Control Module Point Query
plscpcg.book Page 401 Monday, May 28, 2001 10:11 AM