![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-v2-0/cx-supervisor-v2-0_user-manual_744213234.webp)
OMRON
CHAPTER 12 – Databases
Release 2.0
Page 211
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.
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 modifications to data in a connection, regardless of the
Recordset. A transaction is started by calling DBExecute with the 'BeginTrans' command. From that
point, any request to add, modify or delete records are stored instead of being immediately processed.
The Transaction is completed either by calling DBExecute with the 'CommitTrans' command, which
processes all the stored requests in one go, or by calling DBExecute with the 'RollbackTrans'
command, which discards all the stored requests leaving the database as it was when the Transaction
started.
Nested Transactions
Transactions may be nested, that is a new transaction may be started before the preceding transaction
has been completed. In this case, any 'CommitTrans' or 'RollbackTrans' commands relate to the most
recently started transaction, and any further 'CommitTrans or 'RollbackTrans' commands relate to the
transaction begun before it.
Note:
Care should be taken to ensure that each 'BeginTrans' is matched with a
'CommitTrans' or 'RollbackTrans' to ensure that your work is saved or discarded as
required. If there are any pending transactions when a connection is closed, the
user will be prompted to either commit or rollback these outstanding transactions.
A DBExecute command 'TransCount' is available which returns the number of
pending transactions.
Note:
Not all Providers support use of Transactions.
Summary of Contents for CX-SUPERVISOR - V2.0
Page 2: ...CX Supervisor User Manual Software Release 2 0...
Page 3: ......
Page 5: ...CX Supervisor User Manual OMRON Page ii Revision 2 0...
Page 7: ...CX Supervisor User Manual OMRON Page iv Revision 2 0...
Page 11: ...CX Supervisor User Manual OMRON Page viii Revision 2 0...
Page 13: ...CX Supervisor User Manual OMRON Page x Revision 2 0...
Page 15: ...CX Supervisor User Manual OMRON Page xii Revision 2 0...
Page 17: ...CX Supervisor User Manual OMRON Page xiv Revision 2 0...
Page 19: ...CX Supervisor User Manual OMRON Page xvi Revision 2 0...
Page 21: ...CX Supervisor User Manual OMRON Page xviii Revision 2 0...
Page 23: ......
Page 67: ......
Page 97: ......
Page 137: ...CHAPTER 7 Graphics Library OMRON Page 114 Release 2 0...
Page 183: ...CHAPTER 9 Animation OMRON Page 160 Release 2 0...
Page 215: ......
Page 263: ......
Page 269: ......
Page 274: ...OMRON CHAPTER 16 Connecting to Omron Industrial Components Release 2 0 Page 251...
Page 275: ......
Page 285: ......
Page 319: ......
Page 331: ......
Page 351: ......
Page 359: ...GLOSSARY OF TERMS CX Supervisor User Manual OMRON Page 336 Release 2 0...