The SQL Trigger block execute SQL commands based on a specific time and date or an event. Using this feature, the block can select data from a relational database for use in the process database or save process data in your relational database at predefined intervals.
You can also configure the SQL Trigger block for manual use by allowing operators to manually trigger it. By manually triggering the block, operators can update the relational database or retrieve data from it on an as-needed basis. To configure the block for manual use, place the block in Manual mode and create a Data link to the field A_TRIP. After completing these tasks, operators can manually trigger the block by entering a 1 into the field.
