2022.2

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.
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.
Page 66