![background image](http://html1.mh-extra.com/html/omron/cx-supervisor-v2-0/cx-supervisor-v2-0_user-manual_744213226.webp)
OMRON
CHAPTER 12 – Databases
Release 2.0
Page 203
Pessimistic
Locks records when you start editing and releases the lock when Update() (or
Cancel()) is called, no need to worry about a conflict with other users, but can cause
records to be locked for long periods of time preventing other users from accessing
the same records.
Optimistic
Locked only when the Update() method is called, therefore changes can be made to
records without creating a lock, conflicts have to be catered for because someone else
might have changed the record between the time you started editing and the time you
called Update().
Note:
If the Connection is open when a Recordset is added the Combo boxes for ‘Table
Name’ and ‘Server Query’ will be automatically populated with valid entries for
the selected Database
.
When the ‘Add Recordset...’ dialog is closed an attempt will
be made to open the newly configured Recordset.
Configuring Field Associations
Field associations provide a means of connecting CX-Supervisor Points with fields (i.e. columns of
data) in a Recordset, thus enabling data transfers to be made between Points and Records
.
By
creating a Field Association for each field in a record, data can easily be read from a record in the
database to its associated points, and written from the points to the current record in the database
.
Once a Recordset has been added to a Connection in the Workspace, the right menu option ‘Add
Field...’ will be enabled
.
Selecting this option will invoke the following dialog:
Name
A unique Field name will be automatically provided
.
This can be modified to provide a more
meaningful name if required.
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...