2019.1

Table Of Contents
l
Database connection string: Enter a variable connection string in this box. To do
this you may begin by clicking to create an ODBC connection string to the data
source and paste the string automatically to this box. Note that if a login name and
password are required to connect to the database, a dialog box is displayed and the
information you enter is saved in the configuration of the PlanetPress Workflow
Database action task. Another option, if a database connection string (not a
database path and name) was already entered in the Database Connection tab, is ti
simply copy and paste it to this box. Bear in mind that if the Parse normally option is
not selected, any backslashes included in the connection string that is not doubled
will be disregarded. Once your connection string is displayed in this box, you can
edit it by adding variables or data selections.
l
SQL statement: Enter your SQL statement. Remember that you may use variables
and data selections in your statement.
On Error Tab
For a description of the options on the On Error tab see "Using the On Error tab" on page88.
Miscellaneous Tab
The Miscellaneous tab is common to all tasks.
It contains a text area (Task comments) that lets you write comments about the task. These
comments are saved when the dialog is closed with the OK button and are displayed in the
Task Comments Pane.
Check the option Use as step description to display the text next to the icon of the plugin in
the Process area.
The tab also provides an option to highlight the task in "The Process area" on page769 with
the default color, set in the Preferences (see "General appearance preferences" on page659),
or the color selected or defined under Highlight color on this tab.
To revert the selected highlight color to the default color, open this tab, turn the Highlight option
off and close the dialog with the OK button; then turn highlighting back on.
Highlighting can also be turned on and off via the task's contextual menu and with the Highlight
button on the View ribbon.
Decompress File(s)
Decompress File action tasks decompress zipped job files (files compressed as zip files).
Page 331