Configuring Schemas
SECTION 12 Databases
192
12-6
Configuring Schemas
Schemas enable information about a Database to be obtained from a
Provider. There are a large number of Schema Types available. The most
useful feature of schemas is the ability to obtain Table and Query names from
the Database, in fact schemas are used by the Development Environment to
populate the Combo boxes when working with 'live' connections.
The information to be returned from the Provider is determined by specifying a
Schema Type and a Criteria. The Criteria argument is an array of values that
can be used to limit the results of a schema query. Each Schema type has a
different set of Criteria that it supports.
A Schema is configured by selecting the desired Connection and choosing the
right menu option 'Add Schema…' to invoke the following dialog box:
12-6-1 Name
A unique Schema name will be automatically provided. This can be modified
to provide a more meaningful name if required.
12-6-2 Point
The name of an array point which will hold the results of the schema request.
The Browse button may be used to select a current point, or add a new one.
12-6-3 Type
The Type list will be populated with a selection of available Schema Types.
12-6-4 Criteria
The Criteria list shows the available Criteria for the given Schema Type.
12-6-5 Filter
The Filter list is used with certain Schema types to reduce the information
returned.
12-6-6 Read on Connection
If checked, the Schema results are automatically obtained when successful
connection to the database is achieved.
12-6-7 Preview
If the Connection is live, then the Preview button will be enabled on the dialog
box, which allows you to view the results of the configured Schema.
The Schema 'Type', 'Criteria' and 'Filter' values can be modified at Runtime via
the DBSchema() function.
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...