SQL Trigger blocks automatically execute SQL commands when placed in Automatic mode, not in Manual mode. However, an operator can manually trigger a SQL Trigger block through a Data link that uses the A_TRIP field or through the Database Manager. When manually triggered, the block executes SQL commands as if it were in Automatic mode.
If an SQL Trigger block is monitoring the CLOSE to OPEN state of a digital block, the SQL Trigger block activates when the digital block opens. If the SQL Trigger block is placed in Manual mode before the digital block opens, the SQL Trigger block does not activate until it is switched to Automatic mode.
