2022.2

Note: Since the Workflow tool is a 32-bit application, it can only use 32-bit ODBC
data sources. Make sure you use the proper Windows application (ODBC Data
Sources (32-bit)) to create and manage data sources that can be used in Workflow.
5. Click Edit SQL to create the SQL query by hand to define the SQL query that retrieves the data
your document requires.
6. Set the properties that define a record set:
l
Condition: Select the condition that signals the end of a record set. Three possibilities
exist: create a new record set for each record, create a new record set after every x
records, or create a new record set when the value of a specific field changes.
l
Sort on condition field: Select this if the condition you set is to create a new record set
when the value of a specific field changes, and you want to sort the records before applying
that condition.
l
Maximum records per record set: Set either the number of records in each record set, or
the maximum number of records in a record set. An individual record set can contain a max-
imum of 4000 records.
7. Set the number of records you want to include in the sample data file. The number of records you
set should provide a reliable sample to ensure your document executes properly with any of the
data it may encounter at runtime.
l
All: Select to include all records in the database in the sample data file.
l
Records: Select to define the range of records you want to include in the sample data file.
Entering an SQL query
1. In the Database Connection dialog box, click Edit SQL.
2. If necessary, click Show Tables to display, in the Tables area, a list of the tables available in
the database.
3. In the SQL Query Entry area, enter the SQL query. The following two sample queries both
retrieve all the fields in the Orders table. The second sorts the resulting records on the Date field.
SELECT * FROM [Orders]
SELECT * FROM [Orders] ORDER BY [Date]
4. Click Test SQL to verify the query you entered is a valid SQL query.
5. Define whether you want PlanetPress Design to automatically enclose table names and field
names in square brackets.
Page 65