To Next Page

To Previous Page

Configuring Schemas SECTION 12 Databases

194

Schema Foreign Keys PK_TABLE_CATALOG

PK_TABLE_SCHEMA

PK_TABLE_NAMEFK_TABLE_CATALOG

FK_TABLE_SCHEMA

FK_TABLE_NAME

Schema Indexes TABLE_CATALOG

TABLE_SCHEMA

INDEX_NAME

TYPE

TABLE_NAME

Schema Key Column

Usage

CONSTRAINT_CATALOG

CONSTRAINT_SCHEMA

CONSTRAINT_NAME

TABLE_CATALOG

TABLE_SCHEMA

TABLE_NAME

COLUMN_NAME

Schema Primary Keys PK_TABLE_CATALOG

PK_TABLE_SCHEMA

PK_TABLE_NAME

Schema Procedure

Columns

PROCEDURE_CATALOG

PROCEDURE_SCHEMA

PROCEDURE_NAME

COLUMN_NAME

Schema Procedure

Parameters

PROCEDURE_CATALOG

PROCEDURE_SCHEMA

PROCEDURE_NAME

PARAMTER_NAME

Schema Procedures PROCEDURE_CATALOG

PROCEDURE_SCHEMA

PROCEDURE_NAME

PROCEDURE_TYPE

Schema Provider Specific See Remarks

Schema Provider Types DATA_TYPE

BEST_MATCH

Schema Referential

Constraints

CONSTRAINT_CATALOG

CONSTRAINT_SCHEMA

CONSTRAINT_NAME

Schema Schemata CATALOG_NAME

SCHEMA_NAME

SCHEMA_OWNER

Schema SQL Languages <none>

Default Chapter1
- User Manual1
Notice2
- Trademarks and Copyrights2
- Copyright2
- Table of Contents4
Section 118
Graphics Editor18
- About the Graphics Editor18
- Palette Bar18
- Graphic Object Bar20
- Control Bar20
- Status Bar24
- Text Bar24
- Grid26
- Tip of the Day26
Pages28
Section 228
- Creating a Page28
- Amending a Page28
- Defining the Properties of a Page29
- Printing a Page30
- Saving a Page to a Project32
  - Save33
  - Closing a Page33
- CX-Supervisor Preferences33
Section 336
Points36
- What Is a Point36
- About the Point Editor36
- Viewing Points in the Point Editor36
- Creating a Point39
- Amending an Existing Point44
- Deleting an Existing Point44
- Quick Creation of Many Points45
- Runtime Point Maintenance46
- Optimisation of PLC Communications46
  - Creation of an "Array" Point46
- Point Import47
- System Points47
- Printing Points51
- Embedding Point Values in Text51
  - Using Format Specifiers52
Section 454
Objects54
- Editing Objects54
- Creating and Editing Graphic Objects55
- Creating and Editing Control Objects56
- Manipulating Objects69
- Point Substitution73
  - Example73
- Applying Tooltips74
- Using the Floating Menu75
Section 576
Activex Objects76
- Overview76
- Inserting a New Object76
- Editing Properties at Design Time76
- Reading and Writing Properties at Runtime77
- Calling Methods at Runtime78
- Responding to Events78
Section 680
Projects80
- Overview80
- Runtime Editions80
- SECTION 6 Projects80
- Creating a Project81
- Amending a Project81
- Saving a Project81
- Printing a Project81
- Device Configuration82
  - Creating a PLC Connection82
  - Modifying a PLC Connection84
  - Removing a PLC Connection84
  - Accessing PLC Connection in Runtime85
- Fins Gateway Option86
- Trajexia Devices87
- Settings90
  - General Settings90
  - Runtime Settings91
- Runtime Security99
  - Configured Users99
  - Linking CX-Supervisor Users with Windows Users101
  - Menu Option Access Levels101
  - Exit Level102
- Compiling and Running a Project102
  - Building a Project102
  - Running a Project102
- Running a Project with CX-Simulator103
  - Requirements and Limitations103
- Save Runtime as103
- Create Runtime Install Disk104
- Project Information104
- Alias Definitions105
- Find105
- Output Window106
- Navigating Projects with the Workspace106
- Project Editor107
  - About the Project Editor107
  - Viewing the Contents of a Project107
  - Opening a Page Via the Project Editor108
  - Adding Pages to a Project108
  - Removing Pages from a Project108
  - Linking Pages in a Project108
  - Selecting Pages for Display on Run108
  - Changing the View Mode108
  - Viewing Project Details108
  - Multiple Selection109
- Printing from the Project Editor109
  - Print Setup109
  - Print Preview109
  - Printing109
- Navigating Pages Using Workbook Mode109
- Using Full Screen Mode109
Section 7110
Graphics Library110
- Overview110
- Manipulating Objects111
- Printing the Graphics Library113
  - Print Preview113
  - Printing114
Section 8116
Alarms116
- What Is an Alarm116
- Alarm Settings116
- SECTION 8 Alarms116
- Viewing the Contents of the Alarm Database117
- Creating a New Alarm118
  - Alarm Header Information119
  - Alarm Type120
- Updating an Existing Alarm122
- Copying an Existing Alarm Definition122
- Deleting an Existing Alarm123
- Printing Alarms123
- Alarm Reporting in Runtime123
Section 9126
Animation126
- Associating Points with Actions and Events126
- Animation Editor126
- Runtime Actions131
Section 10154
Recipes154
- What Is a Recipe154
- Recipe Components154
- Viewing Recipes in the Recipe Editor154
- Creating a New Recipe155
- Updating an Existing Recipe158
- Copying an Existing Recipe Definition159
- Deleting an Existing Recipe160
- Recipe Security Levels160
- Printing Recipes160
  - Print Preview160
  - Printing160
- Using Recipes in Runtime161
Section 11166
Data Logging166
- What Is Data Logging166
- Data Log Editor166
- Data Logging at Runtime170
  - File Management170
  - Data Records172
- Data Log Viewer Component (V2.0 and V1.8)173
- Remote Data Log Viewer176
- Data Log Export Facilities176
- Data Logging178
  - Add Database Link Dialog178
  - Add Field Link Dialog179
Section 12182
Databases182
- Database Connection Editor182
- Configuring a Connection183
- Configuring Recordsets188
- Configuring Field Associations190
- Configuring Parameter Associations191
- Configuring Schemas193
- Using Transactions196
  - Nested Transactions197
- Saving Recordsets as XML197
- Datashaping198
- Examples199
Section 13202
CFR (Title 21 Part 11) Functionality202
- Overview202
- Supported Databases202
- CX-Supervisor Runtime User and Audit Trail Userid202
- Creating / Running a CFR Application (Microsoft Access)203
- Logging Audit Trails to an SQL Database211
- Further Settings and Configuration214
- How to Access Information from a CFR Database218
  - Using CX-Supervisor218
  - Using Microsoft Excel219
- Limitations222
Section 14224
Standard Web Pages224
- Overview224
- Access224
- Pages224
- Configuration225
- Default Port225
- DCOM Settings225
- Error225
- Limitations225
Section 15226
Multilingual Features226
- Development Features226
- SECTION 15 Multilingual Features226
- Runtime Language Features227
  - Setting the Default Language227
- Runtime Multilingual Features228
  - Changing Language at Runtime228
  - User Defined Text229
- Translating User Defined Text with the Translation Tool229
- Translating User Defined Text Manually231
- Configuring Windows for Language Support232
- Adding Unsupported Runtime Languages234
- Data Log Viewer234
- Standard Web Pages234
- Popup Keyboard Layout235
Section 16236
Application Analysis / Performance Monitor236
- Application Analysis236
  - Data Analysed237
- Performance Monitor240
Section 17244
Using CX-Supervisor as an OPC Client244
- An Overview of OPC244
- Using CX-Supervisor with OPC Servers248
- Using with Omron's CX-Server OPC252
Section 18254
Connecting to a Remote CX-Supervisor Application254
- Two Tier, Client - Server or Master - Slave254
- Peer to Peer254
- SECTION 18 Connecting to a Remote CX-Supervisor Application255
- Distributed Server255
- Redundant Server255
- Creating a CX-Supervisor Server Application256
- Creating a CX-Supervisor Client Application256
Section 19260
Connecting to Omron Industrial Components260
- Adding a Point Linked to a Parameter260
Section 20264
Best Practices264
- Design264
- Performance265
  - Organise the PLC Memory Properly265
- Points267
- Drawing268
- Scripts269
- Data Logging270
Appendix A272
Appendix A Configuring a PC for Remote Connection272
- Configuring a Client PC Running Windows XP Service Pack 2272
- Configuring a Client PC Running Windows XP272
- Configuring a Client PC Running Windows NT or 2000272
- Configuring a Server PC Running Windows XP Service Pack 2273
- Configuring a Server PC Running Windows XP273
- Configuring a Server PC Running Windows NT or 2000273
Appendix B276
Frequently Asked Questions276
Appendix C Troubleshooting300
- How to Diagnose Problems300
- Point Maintenance300
- C.2 Point Maintenance300
- PLC Data Monitor300
- CX-Supervisor Performance Monitor300
- Diagnostics Dialog Box302
- Scripting Errors303
- PLC Maintenance Dialog Box304
- C.6.4 Design Errors304
- Database Errors304
- C.8 Database Errors304
- How to Create Steps to Reproduce304
- Information Necessary to Send to Support305
Appendix DCX-Server Error Codes306
Appendix E308
Appendix E Using with the Omron Dyalox308
- General Use308
Appendix F Obsolete Features310
- Windows 98, Windows ME, Windows NT310
- Configuring a OPC/DCOM Client PC Running Windows 98 or Me310
- Configuring a DCOM / OPC Server PC Running Windows 98 or Me311
- Dde312
- OLE Automation318
- OLE Overview318
  - F.5 OLE Automation318
  - F.6 OLE Overview318
- Object Packager319
Appendix G Glossary of Terms324
Appendix G Glossary of Terms328
Revision History332

Brand	Omron
Model	CX-Supervisor
Category	Software
Language	English

Omron CX-Supervisor User Manual

Table of Contents

Other manuals for Omron CX-Supervisor

Questions and Answers:

Omron CX-Supervisor Specifications

Related product manuals