Configuring Parameter Associations
SECTION 12 Databases
191
Parameter associations provide a means of supplying values to parameters
whenever a Server Query is run. Each required parameter defined within the
query is associated with a point or constant value. At the time the Query is run,
the current value of the point (or the constant value) is passed to the query.
Under the Development Environment the points default value is used.
Parameter Associations are added by right-clicking the Recordset and
selecting 'Add Parameter…' from the popup menu. The following dialog box is
shown:
12-5-1 Name
A unique Parameter Association name will be automatically provided. This can
be modified to provide a more meaningful name if required. By convention,
this is made the same as the name of the parameter defined within the
database but this is not essential.
12-5-2 Index
The index is used to determine which parameter in the Query to associate the
value with. The index is automatically incremented for each parameter that is
added to the Recordset.
12-5-3 Data Type
The Data Type list will be populated with a selection of available data types.
The correct data type for the parameter being configured must be selected,
otherwise the Recordset will fail to open.
12-5-4 Use point to hold parameter value
When unchecked, the constant Value specified is passed as the parameter to
the query. When checked, the current value of the point is passed as the
parameter.
12-5-5 Point
The name of the point to be used. The Browse button may be used to select a
current point, or add a new one.
12-5-6 Value
The constant value to be used.
Summary of Contents for CX-Supervisor
Page 1: ...CX Supervisor Software Cat No W10E EN 01 User Manual Software Release 3 1...
Page 3: ...Copyright Notice 2...
Page 16: ...15...
Page 17: ...16...
Page 27: ...Tip of the Day SECTION 1 Graphics Editor 26...
Page 35: ...CX Supervisor Preferences SECTION 2 Pages 34...
Page 79: ...Responding to Events SECTION 5 ActiveX Objects 78...
Page 115: ...Printing the Graphics Library SECTION 7 Graphics Library 114...
Page 181: ...Data Logging SECTION 11 Data Logging 180...
Page 201: ...Examples SECTION 12 Databases 200...
Page 243: ...Performance Monitor SECTION 16 Application Analysis Performance Monitor 242...
Page 253: ...Using with Omron s CX Server OPC SECTION 17 Using CX Supervisor as an OPC Cli 252...
Page 259: ...Creating a CX Supervisor Client application SECTION 18 Connecting to a remote CX 258...
Page 263: ...Adding a Point Linked to a Parameter SECTION 19 Connecting to Omron Industrial 262...
Page 271: ...Data Logging SECTION 20 Best Practices 270...
Page 275: ...Configuring a Server PC running Windows NT or 2000 Appendix A Configuring a PC 274...
Page 277: ...Appendix B Frequently Asked Questions 276...
Page 296: ...Appendix B Frequently Asked Questions 295...
Page 297: ...Appendix B Frequently Asked Questions 296...
Page 298: ...Appendix B Frequently Asked Questions 297...
Page 299: ...Appendix B Frequently Asked Questions 298...
Page 333: ...Revision history 332...