CHAPTER 12 – Databases OMRON
Page 204 Release 2.0
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.
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.
Field Property
The type of information from the field to be transferred, the following options are available:
Value default - the assigned value of the field
Name the name of the field / column title
Type the fields Data Type
Size the maximum width of the field
Add used to add new fields to a record
Note: The Name, Type and Size properties are fixed for all entries of the column, whereas
the field value depends on the current position of the Recordset.
Note: The ‘Add’ property is specifically designed to enable fields to be added together to
create new records. They are not involved in any read operations, as with the other
field property types. For this reason, the ‘Automatically read on open’ checkbox is
disabled when this type is applied. When creating configurations to add new
records you will need to create a ‘Add’ association for every field required to
‘create’ a valid record i.e. primary keys, non-null values etc. need to be catered for.
See DBAddNew() for more details.
Access field by index
When checked, a numeric index is used to identify a particular field instead of its name. This is
useful if you want to configure generic field associations.
Automatically read on open
When checked, the data is transferred from the Recordset field to the associated point, when the
Recordset is opened.
To Next Page
Loading...
Need help?
General