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.
To Next Page
Loading...
Need help?
General