2018.2

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 maximum 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 67