Download FactorySQL 4.1 User Manual

 Group Options - Action Tab
The Action tab is where the core settings for a group's execution are configured. You can set the update interval
and mode, the database connection used, and the table in the database used. You can also select other features
and data that will be tied to the group.
Update Rate: Defines a number and interval unit for the timing of a transactional group. The group will run once
when you start the group then again on that interval. For example, selecting 2 minutes means that FactorySQL will
inspect the group for changes every two minutes. Update Mode:
Defines the "direction" that data is updated between OPC addresses and the database
OPC->DB: Reads the PLC and writes values to the database. This mode is most often used for data logging with the
"insert new record" option, or to show realtime status with "update/select" a given record selected.
DB->OPC: Reads the database and writes changed values to the PLC.
Bi-directional (OPC wins): Reads the database and PLC. If either side has changed during the update interval and
the other hasn't, both will take the new value. If both sides have changed, the database value will be overwritten
by the PLC value.
Bi-directional (DB wins): Reads the database and PLC. If either side has changed during the update interval and
the other hasn't, both will take the new value. If both sides have changed, the PLC value will be overwritten by the
database value.
Page 71