2019.2

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