Omron CX-Supervisor, User Manual

Page: 190 / 334

Configuring Field Associations SECTION 12 Databases
189
12-4 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. When 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 box:
12-4-1 Name
A unique Field name will be automatically provided. This can be modified to
provide a more meaningful name if required.
12-4-2 Point
The name of the point that will be used in data transfers. The Browse button
may be used to select a current point, or add a new one.
12-4-3 Field
The name of the Recordset field to be associated with the above point. If the
Recordset is open, this list will automatically show all available fields.
12-4-4 Field Property
The type of information from the field to be transferred, the following options
are available:
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 box is
closed an attempt will be made to open the newly configured Recordset.
Value default - the assigned value of the field
Name the name of the field / column title
Type the fields Data Type