![background image](http://html1.mh-extra.com/html/omron/cx-supervisor/cx-supervisor_user-manual_744211196.webp)
Using Transactions
SECTION 12 Databases
195
12-7
Using Transactions
Modifications of data in the database i.e. adding, modifying and deleting
records, can be grouped so that all modifications take place at the same time.
This group of modifications is called a Transaction. A Transaction includes any
Schema Table
Constraints
CONSTRAINT_CATALOG
CONSTRAINT_SCHEMA
CONSTRAINT_NAME
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
CONSTRAINT_TYPE
Schema Table Privileges
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
GRANTOR
GRANTEE
Schema Tables
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
TABLE_TYPE
Schema Translations
TRANSLATION_CATALOG
TRANSLATION_SCHEMA
TRANSLATION_NAME
Schema Usage Privileges OBJECT_CATALOG
OBJECT_SCHEMA
OBJECT_NAME
OBJECT_TYPE
GRANTOR
GRANTEE
Schema View Column
Usage
VIEW_CATALOG
VIEW_SCHEMA
VIEW_NAME
Schema View Table
Usage
VIEW_CATALOG
VIEW_SCHEMA
VIEW_NAME
Schema Views
TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
Note:
The actual schemas are defined by the OLE DB specification and Providers
are not required to support all of the OLE DB standard schema queries.
Specifically, only 'Schema Tables', 'Schema Columns', and 'Schema Provider
Types' are required by the OLE DB specification. However, the provider is not
required to support the Criteria constraints listed above for those schema
queries.
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...