2019.1

Alternate syntax(not recommended): Select to prevent PlanetPress Design from
automatically enclosing the names of any database tables and fields that appear in the
SQL query in square brackets when it exits the advanced SQL Statement dialog box.
6.
Client side cursor: Select to download result sets to client computer running the SQL
query. Under some circumstances, client side cursors may be slightly less efficient than
server-side cursors, but they may also provide additional functionality, depending on the
type of query that is issued.
7.
Click OK to return to the Database Connection dialog box.
Opening a previously used data file
PlanetPress Workflow also keeps the last 9 used data files in memory, which you can reopen to
use in the same process, or in a different one.
To reopen a sample data file:
1.
Click the Debug tab in the PlanetPress Workflow Ribbon.
2.
Click on Reopen Data File in the Data group.
3. Click on one of the data files in the list.
4.
Use the Data Selector to change the emulation options if necessary.
5.
Click OK on the Data Selector.
Database emulation
The Database emulation differs from other emulation types. With other emulations, data is
pushed either to PlanetPress Workflow processes running on servers, or to PlanetPress
Design documents residing on a printer. But in the case of the Dababase emulation, data must
be pulled from the data source: a query must be performed on the database to extract the
relevant data.
When generating output from the design tool (which is the Designer in Connect, or Design in
PlanetPress suite) one can open the document and then use the Data Selector to select a
database. By making a connection to the database, its structure can be accessed and it
becomes possible to determine how data is to be pulled into the document.
In a Workflow process, the database query has to be performed automatically. This can be
performed by the "Database Query" on page326 Action task. The task generates a data file
that it passes to the following task, be it another Action task, or any Output task. For help on
setting up the database emulation see: "Choosing a database sample file" on page66.
Page 68