8.4

l
Export Config: Click to export the currently displayed properties of the PlanetPress Workflow action
task. The exported configuration can then be reused on other PlanetPress Workflow workstations.
Dynamic SQL tab
l Use dynamic values at run-time: Select to use a dynamic database connection string and / or SQL
statement at run-time. Check this box to enable the options included in this group (this disables the
corresponding options in the General tab).
l Parse normally: Select to interpret any backslashes included in the database connection string
as backslashes. If this option is not selected, any backslash that is not doubled will be
disregarded.
l Expect record set:Check if you are expecting a result from the database after executing the
SQLquery. If the query is expecting a record set in return and does not return one, the task will
trigger an error.
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
The On Error Tab is common to all tasks. Details can be found on " Task Properties Dialog" on page 587.
By default, any action task, branch, splitter or condition that generates an error will simply be ignored, and
the task just under it (not within a branch)will be given control of the job file without any modification. Any
initial input task that generates an error will stop the process from running as a whole, and output tasks will
not generate output. The On Error tab can be used to overwrite the default behaviors.
l Send to Process: Check this option to send the job file to an error management process.
l Error Process drop-down:Enabled only when the Send to Process option is checked. Lists any
process of which the initial input task is the Input Error Bin task.