Specifications

Configuring the PlantScape ODBC Driver
PlantScape Server and Client Configuration Guide 403
The relationship between the Type field and the TextValue and NumericValue
fields is as follows:
• If the parameter type is TEXT, then the value is shown in the TextValue
field.
• If the parameter type is NUMBER, the value is shown in the NumericValue
field.
• If the parameter type is ENUM, the value is shown in both the TextValue
and the NumericValue field.
• If the parameter type is INVALI, no data is shown in either field.
The following table summarizes this relationship.
You can retrieve more than one parameter in a query by setting subsequent
ParameterXXX fields to other parameter names; for example, Parameter002 =
PIDA.pv, Parameter003 = PIDA.op.
The number of parameters that you can retrieve in one query might be restricted
by the application you are using. For example, Microsoft Access limits this
number to about 40. The total size of the record being retrieved may also be
limited. If you are retrieving every field for every parameter, the number of
parameters able to be viewed in Microsoft Access will be reduced to 14. This
number can be increased by not requesting fields which you don’t require, for
example the TextValue field for numeric parameters.
The following restrictions apply to queries involving Control Module points:
• Wild cards are not permitted in the parameter names of Control Module
points.
• 'Or' conditions cannot be used in the query.
Applicable Value Field
Type TextValue NumericValue
ENUM
✔✔
TEXT
✔✘
NUMBER
✘ ✔
INVALI
✘ ✘
Table 20.1 Parameter Types and Value Fields
plscpcg.book Page 403 Monday, May 28, 2001 10:11 AM