8.8

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 in the" Task Properties Dialog"
on page777.
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.
Page 304