7.4

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.
All: Select to include all records in the database in the sample data file.
Records: Select to define the range of records you want to include in the sample data file. Use the box that
To enter 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.
7. Click OK to return to the Database Connection dialog box.
Export or Import a Database Emulation Configuration
You use the export and import procedures when you intend to use the same configuration in several documents. You also
export a database emulation configuration when you intend to execute the document in PlanetPress Workflow Tools, and want
to simplify the process of configuring the database plug-in.
The exported configuration file is in XML format and bears the file name extension .cfg.
To export a database emulation configuration:
1. Open the document that uses the database emulation configuration you want to export.
2. Choose Tools | Open Active Data.
3. In the Data Selector, click the Database Emulation Configuration button to display the Database Connection
dialog box.
4. In the Database Connection dialog box, set the password option.Include password on export: Select to
include the password required to access the database, in the exported database emulation configuration.
5. In the Database Connection dialog box, click Export.
6. In the Export Database Configuration dialog box, navigate to the folder in which you want to save the configuration,
enter a name for the exported file, and click Save.
PlanetPress Design exports the configuration and returns the focus to the Database Connection dialog. If you selected
Include password on export, the exported configuration file contains the password required to access the database.
7. Click OK to exit the Database Connection dialog.
8. Click OK.
To import a database emulation configuration:
1. Open the document in which you want to import a database emulation configuration.
2. Choose Tools | Open Active Data.
©2010 Objectif Lune Inc - 95 -