2019.1

Advanced SQL Statement dialog box. The alternate syntax may be required for some
database types.
l
Edit SQL: Click to create and test an advanced SQL query; see "Advanced SQL
Statement Dialog" on page743.
l
Import Config: If you previously created and exported a PlanetPress Workflow Database
Connection configuration, click this button to import it. This saves you the trouble of
configuring the connection every time.
l
Client-side Cursor: When this option is enabled, the complete result set is downloaded
before processing starts, and changing records is done by PlanetPress Workflow. This is
generally faster for queries returning a small number of results ; otherwise the start of the
record processing can be delayed since the whole record set must be downloaded.
Note
MySQL, using ODBC 5.0, must be set to use a client-side cursor.
Microsoft Access will always work better when using a Server-Side cursor.
l
Include password in config: Select to save an encrypted version of the database
password (if any) within the exported configuration.
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.
Page 330