2022.2

Table Of Contents
l
Printer Name (Optional): Name and/or model of the printer.
l
Comments (Optional): Comments about the printer.
The following buttons are available in this dialog:
l
Add: Brings up the Printer Activation dialog. This dialog lets you enter the information for the
printer (see previous section), then click OK to save the new activation.
l
Delete: Removes the currently selected activation from the list.
l
Web Activation: Click to access the online activation manager on our website.
l
OK: Save changes and exit.
l
Cancel: Exit without saving changes.
You can also double-click on any existing activation to edit it.
Advanced SQL Statement Dialog
The Advanced SQL Statement dialog is available by clicking the Edit SQL button from the Database
Query action task. You can enter a custom SQL query in this dialog, using the language supported by
the database you select in the Database Query action task.
The dialog is separated in two parts:
l
The left part displays the available tables in your database. Click the Show Tables button to dis-
play them.
l
The right part displays a default SQL statement which you can modify at your leisure.
l
The bottom part displays the following options:
l
Alternate syntax: Select to prevent 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. The alternate syntax may be required for some
database types.
l
Client-side Cursor: When this option is enabled, the complete result set is downloaded
before processing starts, and changing records is done by PlanetPress. This is generally
faster for queries returning a small number of results ; otherwise the start of the record pro-
cessing can be delayed since the whole record set must be downloaded.
Note: MySQL, using ODBC 5.0, must be set to use a client-side cursor.
Microsoft Access will always work better when using a Server-Side cursor.
l
Expect record set: Check if you are expecting a result from the database after executing
the SQL query. If the query is expecting a record set in return and does not return one, the
Page 709